Best Of
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
Re: Generate Document Error
Yes I have also recently seen this screen and have contacted Tech support.
I experience this issie using a Mac computer running the smartsheet app signed into the Europe region
The temp fix i found is
Sign in via a web page ie Chrome in my case.
If you get the same error try via an incognito web browser. If that works then go back to your web browser and delete cache.
I still have a case number fpr this issue that I'll follow up on again as it's gone silent on the SS Tech support side?
However based on my communication with it is a known issue with the aapp only when signed in to the Euro region.
Regards Brindles
Brindles