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:
Hello.
Please help w a formula to turn the red flag of the 'at risk' column for various number of days before the date set in the Completion Date column.
Thank you.
Dan
=IF([Completion Date]@row >= TODAY(- #), 1)
Give this a try. Just replace the # with however many days you want to trigger the flag.
Thanks very much for your prompt reply and suggestion.
I'll try it and let you know if I succeed, if it works.
Best,
Happy to help.
I have an Action Log and in the log we have a column that identifies the different projects our team leads. There is also a Workstream column, which identifies what workstream is responsible for getting the answer. There can be more than one answer, so we have a dropdown and if multiple workstreams are responsible for the…
So here what I'm trying, I have multiple solution and status for all. Trying to get the total net worth value of order based on solution + individual status. Let's say I want to capture the total revenue for Centralised Inventory with all different status as below: I tried with Sumifs but it's not calculating all values.…
I would love some help troubleshooting a column link issue between two sheets used for department metric scorecards. Sheet 1 (source sheet) is the metric submission sheet where metric owners report quarterly data. Sheet 2 (target sheet) is the scorecard that shows quarterly goals and actuals, with a status symbol for each…
