-
How can I conditionally update a cell but leave the current value there if the condition fails?
I keep track of about 40 active projects in our company. Among other things, I keep one Smartsheet on each project that shows the hours worked by several different functional areas on a week-by-week basis. I only want to put the current week's hours into the project history row for the current week after they have been…
-
Formula question
Hi Smartsheet community! I realize there is a help area for this but I have looked ... read.. googled.. till I'm blue. So this is new and I thought in this NEW COMMUNITY maybe I could shout out for some help. I am trying to do a formula so that the smartsheet can look at a month ( column ) and then determine in another (…
-
Alert for RYG's
One person is wanting to be notified when their RYG ball turns green, which means a document they are needing is complete. In the notifications, I can only choose for her to be notified when that column changes for anyone. Is there a formula I can do that will accomplish this? Blessings, Loann
-
CHILDREN formula in another cell.
I am trying to SUM the indented children rows in another cell that isn't the parent. Is this possible?