Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Anyone help?
Using formulas, you can automate RYG balls to change colors based on the Due Date being 45, 30, or past the due date?
Thanks
Hello,
Try a formula like the following example:
=IF([Due Date]1 >= TODAY(30), "Red", IF([Due Date]1 >= TODAY(45), "Yellow", "Green"))
NOTE: This is an example formula, please refrain form copying and pasting it straight into your sheet as it may not work. You may need to adjust the formula to better suit your needs and match the correct cell references in your sheet.
Details on creating formulas can be found in our help articles:
We have recently experienced an issue with the date field on forms no longer accepting non-date values. This is despite the date column on the sheet being set with the "Restrict to dates only" setting toggled off. The forms have not had any configuration change and have previously accepted non-date values (last recorded…
Hello I have created a calendar from a sheet. In the Map Columns window - number 3 - I can see the Custom Category List Order where I can apply colours In another calendar I cannot see this view - only 'Column Mapping' The only difference being one is a sheet and one is a report. Is this correct? Or am I doing something…
I'm having trouble figuring out what is erroring out in a Bridge script I'm running to update a Sheet Summary item on a sheet. Here are all of the details of the script: The API key and json parameters in the connection are set up correctly, I just cannot figure out why this particular API hook isn't working.
