Sign in to join the conversation:
Hello,
I've set my conditional formatting for rows marked "delivered." However nothing is happening. Any help on what step I may be missing is greatly appreciated. I've attached a screenshot for reference. Thank you.
I'm experiencing a lag in conditional formatting. The rule is defined correctly but the formatting doesn't appear until the page is refreshed. Maybe that's the default behavior, I don't know I'm only at this a few months.
(Update) I just tested and when I try the conditional formatting it changes instantly when I'm checking/unchecking a box. However I just sat with someone this morning and when she changed the value the formatting did not appear without a page refresh. I am the owner of the sheets and my co-worker is viewing the data through a report, .... not the original sheet.
Thank you for your quick answer.
I am indeed the owner. I've refreshed as well. I've gone so far as to close out of Smartsheet and re-open it to make sure the rule is still there. It is there but doesn't show up.
You changed the format only for the task bar (Gantt view). You would need to change the background color of the cell. See screenshot. You'll want to change the circled one. You changed the underlined one.
Ah ha!!!!! That is it! Thank you so much!
Happy to help. I did the same thing (with much frustration) many times when I first started using Smartsheet. It wasn't until I started using Gantt view that I realized what was happening.
New to the community, but not new to Smartsheet. Anyone know when conditional formatting will include currency, percentage, and decimal functionality?
Using several hidden columns to filter rows and change font to bold and back. Works great, but can't get rows that change dynamically to change from coma format to dollar format with conditional formatting.
Anyone have a workaround? If I come up with something on my own, I'll post it here.
Edited...
Can you provide some screenshots with confidential/sensitive data removed, replaced with "dummy data", or blacked out?
If you can show an example of what you are trying to do along with an example of what is actually helping happening, we may be able to come up with a solution for you.
Hi Jeff,
Great idea! That would be a great addition to Smartsheet features.
Please submit an Enhancement Request when you have a moment.
I'll get back to you if I figure out a workaround!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Team -
I'm having the same issue as Mike L. I've got conditional formatting set up on my owned sheet and the formatting works fine (and immediately), but on the report (based off the sheet) if I make a change that should be affected by the conditional formatting it doesn't change. After I save it doesn't change. Only after I refresh the page does it change.
Has anyone done this? Can you add a form link (status update form) to a roll up sheet automatically once the project is provisioned in Control Center. Essentially the end goal is that already created template form, I would like the link to auto populate the form link from the status update sheet after provisioning so users…
I thought it would be easiest to create a reference sheet to house dates so I'm not constantly creating timeframe stipulators in my sheets, especially now that I am trying to create portfolio level rollups. When I observe the switch over from Mar to April, it seems like in order for the reference sheet to show April 1, I…
I'm looking for my source sheet for a form that is no longer active. I have the published link, but that is turning up as no longer published. My questions: Is it possible that the sheet was deleted? Is there a way for me to locate the source sheet? I thought I knew the title of the sheet, but when I search for it, it's…
