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…
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 wan…
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 fo…
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…
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 e…
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 …
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 automatio…
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".…
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 th…