-
Hidden sheets in a Resource View
Hi I have a Resource View and some resources are shown 150%, as they are mentioned in a long-forgotten sheet (displayed here as "Other sheet") that is not maintained anymore, not shared and the owner is unknown. How can I figure out where this particular resource is used please? Thanks Attila
-
Auto Populate Due date
Hi, I manage to get SS auto populate the due-date base on the start date. But is it possible to make the due date calculation is not including the weekend? Example: Start Date = 19 May 2017, Friday Due Date is after 4 day of the start date, it should be 23 May 2017. But becasue of the Sat & Sun, the due date should delay…
-
"Gantt Chart" and "Sort by Date" do not work as expected
I am trying to create a consolidated sheet for past projects. I have inserted each project's Start-date and End-date as links from other cells. However the gantt chart is not correct, please see the first attached screen; i.e. missing project A and project E. Also if I try to sort by start date, the sorting result is…
-
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?
-
Printing Conditional Formatting formulas
I have about 30 columns in my smartsheet tab that are populated via a webform. Is there a way to print the conditional formulas for the columns in one document so to audit the formulas for accuracy?
-
How to use the Effort (People) Symbols with Formula
Hi Smartsheet Community! I have been looking for different help tips on How Tos, on using certain symbols and my search has been coming up very vague. I can't seem to find anything on how to use the Effort Symbols (The 1-5 people) and/or little in regards the uses of the directional symbols. I thought maybe I found…
-
Alerts for Blank Fields
I want to create an alert or reminder when a field on a certain row is blank. It can't be a required field because the data is entered after the row is created. Does Smartsheet have this functionality? I don't see these options available today but thought I would ask if others have attempted this. I am currently exporting…
-
Workflows for Alerts
I've been asked to come up with a way for smartsheet to send an automatic reminder to "Assignee" two days before the target date. This is no big deal and actually very simple to set up; however, the second part is "if the date completed field is empty and equal to or greater than the target date". I attempted to do this…
-
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.…
