-
Update Requests Limited?
I am sending update requests for a sheet that has initial items filled in by formulas - dates, as well as "Yes/No" dropdown selections. This makes it easy for the person who starts with this template to put in suggested initial dates, then ask for exact dates from these directly involved. In the sheet the editor can…
-
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?