Comments (2)
I just have a little test, if I use == 0 to identify did the date is not provided, some results are unexcepted. if I use == null, the cell content will become empty.
=if([$Expiry_x0020_Date] >0, '100%', '50%')
has date show 100%
no date show 50%
=if([$Expiry_x0020_Date] <0, '100%', '50%')
has date show 50% Unexcepted, should be 100%
NO DATE show 50%
=if([$Expiry_x0020_Date] ==0, '100%', '50%')
has date show 50%
no date show 50% Unexcepted, should be 100%
=if([$Expiry_x0020_Date] <=0, '100%', '50%')
has date show 50%
NO DATE show 100%
=if([$Expiry_x0020_Date] >=0, '100%', '50%')
has date show 100%
NO DATE show 100%
from list-formatting.
Looks like you figured out the first issue with spaces in the name (you use the internal column name which includes the escape characters).
As for checking if the date is blank, there's another issue here with some great solutions: #91
If you are still having trouble, please let us know, thanks!
from list-formatting.
Related Issues (20)
- Sample - yesno-icon-color not working as intended HOT 5
- I have a question about honeycomb-link when used with an embedded webpart HOT 2
- I have a question about formatting a column that contains a JSON string HOT 2
- I have a question about JSON code in lists HOT 2
- Generic Gantt chart - Date field cannot be edited HOT 6
- Birthday Sample, does not populate birthday. HOT 5
- No longer works as it used to: form-samples/wrapped-body HOT 2
- Gallery View: Scaling of SVG files HOT 1
- honeycomb SAMPLE has made me sad, please help HOT 6
- Changes made by GENERIC-UPDATE-BUTTON are not immediately visible to other users HOT 2
- group-header-remove-column-name-clickable has made me sad, please help HOT 5
- Links do not open in Microsoft Lists App in some samples HOT 7
- I have a question about Praise Cards HOT 3
- Remove 'Editing' Worry From 'Custom Charts' - view-samples/custom-charts HOT 1
- group-header-remove-column-name has made me sad, please help HOT 4
- text-qrcode question/help HOT 5
- View Formatting - Group - GroupProps To Trigger Expand / Contract Without Malforming Header HOT 5
- Birthday Sample List formatting not working with @now HOT 1
- [SUGGESTION] Color Picker Potential HOT 5
- Colorful Honeycomb Links HOT 5
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from list-formatting.