-
New notification feature doesn't send an email to all the users specified
I set up a new customized notification yesterday and set up the email delivery for myself and 3 other colleagues. However, I was the only person to receive the notification email this morning. Did I do something wrong or is this a programming issue? I have included a screen capture of the notification set up. Thanks.
-
Formula to move a row to another sheet?
Good morning, I'm hoping I can formulate a column so that if the checkbox is checked, it will move that row to another specified sheet. Can this be done? If column A is checked, move to Sheet B is the basics, but formulas always mess with me. Blessings, Loann
-
Feature Request - Auto format for ranges
It would be extremely convenient if we could set our autoformatting rules for a Row, a range, or even the whole sheet, instead of just one column at a time as is the current configuration. EXAMPLE: I have 15 columns that I would like to apply the same 6 formatting rules to. Currently, that means that I have to define 90…
-
Nested IF statement for RYGB only works in one row
Has anyone come across a scenario where your nested IF statements work perfectly on one row, but when dragged to other rows don't apply the conditions correctly? I've added the following statement to row 47 of my sheet: =IF([Percentage Complete]47 = 100, "Blue", IF([Percentage Complete]47 < 33, "Red", IF([Percentage…
-
Change drip down selection for entire coumn
I have added a column to my sheet that is a drop down list column. I would now like to automatically have these selected as, "Not Started". Is there a way to do this other than going down and automatically updating each cell?
-
Date Formula
Hi I am trying to calculate a date formula but having not luck! I am wanting a main date in my sheet, to trigger dates in other parts of the sheet but cant seem to find a formula which works. I also need to add days into the formula; eg. Project Start Date + 30 days Can someone help please, unsure where I'm going wrong.…
-
"Modified / Modified by" fields
I noticed that when I save a shared sheet, the columns "modified" and "modified by" change to my login and the time stamp when I saved for ALL rown in the sheet. Is it how those column types are supposed to work? In the help contents, I read that those columns change ONLY in the ROW where data has been changed. It doesn't…
-
Enable and Set Up Auto Logout
Is it possible to set Smartsheet up to automatically log off users due to a period of inactivity?
-
Formatting for Project Lists - suggestion
I was hoping there was some formatting option so that when I set a status to complete (either green orb, full circle etc.) that there would be a way for that row to automatically be moved to the top of the sheet. That way the "in progress" and "completed" tasks/projects could be better organized. Just an idea. Thanks
-
Duration minus Actual Effort
We would like to be able to track actual vs estimated duration, as well as the variance. ie: Duration Column 4 days, actual work 2 days, variance -2. Duration Column 4 days, actual work 6 days, variance 2. And be able to roll the totals up at the top of each parent task. If a task is scheduled to take 90 minutes, but we…
