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:
I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line. i've read a lot of the other posts but none of the formulas seem to apply or work when I input them. Please let me know your thoughts. Thank you!
Give this a whirl...
=IF([% Complete]@row = 1, "Complete", IF([End Date]@row < TODAY(), "Overdue", IF([% Complete]@row = 0, "Pending", "In Progress")))
I am trying to make a formula that looks in a column on Sheet A which is a drop down containing all values from a column on Sheet B, finds the match, and then looks in the row in Sheet B where the match is found to find an additional piece of information and pull that back into sheet A. I am thinking I need indexing and…
With card view going away, I've been experimenting with Board view. The board view lags between its cards which is very unproductive. Is there a fix that can be done so that cards in Board do not lag? Mike
I am in conditional formatting and cant seem to figure out how it should be set up. This is what I am looking for. I'd like a cell to turn red if it has been 365 days since the date that is listed in the cell. Any help is greatly appreciated!
