-
Report not updating when adding new sheet
I have a report tracking all new sheets when added to the folder in my workspace. The report does not recognize this new sheet and I have to manually go into every report (many) to add it to the sheet list. Is this an error in the workspace interface or am I missing a checkbox somewhere?
-
I need both dependencies and predecessors
I have used the predecessor column and love it but I need to also have a dependency column. For instance if I have task 1, 2, and 3 and 3 has a predecessor of 2 and 2 has a predecessor of 1 then I want to know that 2 has a dependency of 3. Knowing the predecessor only tells me what needs to be completed before the task. I…
-
Averages
Hello all. Thank you for any help you can provide. I have 5 fields containing averaged numbers. I want to roll them all into 1 field to show the average for that specialty. Anyone know of the right formula to use? In English, I have the average for 5 counties for primary care clinics and want just 1 average for the…
-
More functionality for for rules
The rules feature is nice but it is very limited and only allows to change things from different fonts, colors, strikeouts, etc. I would like a rule that allowed more detailed changes. For example, if column a says completed, changed column L to 100%. There are many different scenarios. We are unable to use the…
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
IF And
Good Day, I need so assistance, I am trying to do the following I want to change my Project stoplight Status Column (RYGB ball) to yellow if the following condition is met if my "# of Days" column is > 138 and my "% Complete" column is < 50% Here is my If condition - =IF(AND(([# of Days]2 > 138, ([% Complete]2 < 50)),…
-
Send Row to another sheet (not via email)
I have multiple sheets with similar columns, and I'd like to be able to send rows between sheets easily. I know I can just cut and paste, but is it possible to make a button or other similar automation that moves the row from one sheet to another? The Send Row function looks close, but I can only find documentation on how…
-
Auto Flagging Yes or No answers
Hey everyone! This is my first post on smartsheet, so please bear with me. I'm trying to build a Production Report. I'd like the Red Flag to turn on whenever the "Was Production Met" column says "No". This is my current formula: =IF([Was Production Met?]1 = 0, 1). I can make it work with a checkbox, but no luck with yes or…
-
Time tracking for Collaborators
Hello If I set up time tracking in a sheet, can that be accessed/used by free collaborators? Thanks Megan
-
date formula referencing specific date cell
Hi, I am working in a date column that has the Effective Date: 05/13/2019. I want the Project Kick-off Date to reference the Effective Date - What formula do I enter so that: (i) the Year is always the year listed in the effective date cell, (ii) month is always January, and (iii) Day is always 01? I have tried this…
