Best Of

Re: Cross sheet references not updating

Thank you all for your patience.

Engineering is actively working on resolving issues with cross-sheet formulas not updating unless the sheet is opened. A fix is expected to be available by Tuesday.

Hope this helps!

Cheers,
Isaac.

Isaac A.

1 ·

Re: Can Smartsheet display five health color indicators?

https://community.smartsheet.com/discussion/comment/484816#Comment_484816

Happy to help!

You can also use them in formulas by surrounding the emojis with "🔵", similar to how you use text in a formula.

Make sense?

✅ 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å

1 ·

Re: Blank rows added to bottom of sheet / form

Hi @MeghanRyan

I hope you're well and safe!

Unfortunately, it's not possible to remove them, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

1 ·

Re: Can Smartsheet display five health color indicators?

https://community.smartsheet.com/discussion/comment/484755#Comment_484755

You can add them to the drop-down column option.

Make sense?

✅ 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å

1 ·

Re: Sort by Date column within the Report - Report pulls in parent and child/ancestor rows

@SSFeatures This report brings in multiple different sheets from various project folders within a workspace as they are created. Ideally, we keep the parent row in as part of the report. Thanks for your feedback!

mmac

1 ·

Re: Is there a workaround for these automations if I have this formula in my Smartsheet?

@Julie Becker thanks for the suggestions. I read the thread and will look into trying to understand the API coding to solve the issue of removing the predecessors. @Paul Newcome is correct. The Move Row automation also is initiating.

I created 2 test SS to see if these automations would work. The Predecessor automation populates "#REF" in the Predecessor column of the successor line of the row that was moved. The row was moved to the other SS so that's a plus.

vntjxnes

1 ·

Re: Export Column Properties

https://community.smartsheet.com/discussion/comment/484833#Comment_484833

In my opinion, exactly as you describe - json for devs; excel/csv for general business user.

Chris Walker

1 ·

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")))), " ")