Best Of
Re: Export Column Properties
In my opinion, exactly as you describe - json for devs; excel/csv for general business user.
Chris Walker
Re: Schedule health formula to display blank symbol
Try:
=IF(AND(ISBLANK(Status@row), ISBLANK([End Date]@row)), "", IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")
Nic Larsen
Re: Change Background Color of Dropdown Bubbles
@S.Stone That's a great solution! I appreciate you sharing it - I'll give it a try too. That makes it much more visible - I like it!!
khelwig
Re: Introducing the Smartsheet Unlocked podcast...
I might be biased but I love this podcast, especially the first episode with Will! 🤩 Great work, Rich.
Alison C.
Re: Auto populate % Completion based on status
This formula would go in the % Complete column
=IF(Status@row<>"", IF(Status@row="Planning", 0.1, IF(Status@row="Build", 0.25, IF(Status@row="Internal Review", 0.35, IF(Status@row="External Review", 0.45, IF(Status@row="Scheduled", 0.65, IF(Status@row="Live", 0.75, 1)))))))
Kelly Moore
Re: Can I Cell-Link between a Sheet and a Report
Seems like every time I search for a need that would simplify and automate a workflow the answer is, "submit a feature request."
Smartsheet - when trying to coordinate lots of data between two different teams managing multiple projects across 30 different countries, a report is a great central location to create only necessary links between domains. A roll up sheet has to be opened to be updated.
Re: Template Downloads
hi @MDVolt ,
I downloaded this template without issues.
Maybe first login to smartsheet go to the templates and try to find it the Project Intake template from inside.
kowal
Re: Template Downloads
You're more than welcome!
Let me know if you can't solve it, and I'd be happy to see if I can add it to mine and share it with you.
Feel free to email me at andree@workbold.com, and I'll share it with you.
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
Andrée Starå
Re: Data Shuttle Not Saving Smartsheets
Ok. I just figured out what is happening. Data Shuttle #2 (which depends on Data Shuttle #1 being complete) is finishing before Data Shuttle #1. They are all currently set up as Run On Attachment, dependent on Smartsheet #1 attachment. I could schedule Data Shuttle #2 to run at a particular time, giving Data Shuttle #1 time to complete, but that time is a bit arbitrary. It varies as to how long it takes for it to run.
Is there a way to chain the workflows so that #2 doesn't kick off until #1 finishes? I haven't been able to find anything to address this one way or the other, although I'm sure this question has been asked previously.
Penny Wilson
Re: Notification triggered from cell change, but not form submission.
Found the answer.
Kowai, you are correct to say we need two workflows, one for the change in cell and another for only adding a new cell. This is the solution that I went forward with.
I reached out to smartsheet and recieved this email.
To explain this message: The workflow for notifying changes in cells has a bug. However there is still a way for the automation to perform your intended behavior. Simply, add an additional condition block where "ATTRIBUTE" is blank.
Thanks everyone,
Smertle_7