-
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
-
Help with nested If formulat
These formulas work independently. I am attempting to combine them into one nested if formula. 1) if the %complete is full, status is green: =IF([% Complete]10 = "Full", "Green" , "Red") 2) if the finish date is greater thant today, status is green: =IF(Finish10 > TODAY(), "Green") 3) if %complete is full and finish date…
-
Comments in Sights
Is there a way to pull comments into a sight? I am new at this and trying to create a dashboard and was hoping to use the comments field and pull it into the dashboard. I have tried to do it straight from the metrics widget but it won't let me select any comments. I have also tried to create a report but it doesn't…
-
Formula with Update Requests
Hello all, Im using Smartsheet to automatize a lead process with around 30 people involved. We get Leads in an external network, I add them to my Smartsheet Sheet and then the one in a contact column gets an automatized notification with the new lead data. After 5 days I need an update with est. values and so on, so I made…
-
Is there an "OR" condition in conditional formatting?
I'm a very new user (1 week) and I am trying to apply conditional formatting if any one of 4 conditions is met. I need an OR statement but can't figure out how to do it, other than to do a separate rule for each condition. I searched the community and help and couldn't find anything about OR conditions. Thanks!
-
RYG Parent/Child Row Status Correlation
Hello, I'm trying to have a formula in my parent row status (red, yellow, green) where it will answer with a "summary" of all the children status. For example, if all 5 children rows were red then the parent row status would turn red. If 3 children rows were yellow and 2 children rows were red then the parent row status…
-
Attach File
I am trying to attache a pdf file that is 1.43 MB. (max file size is 256 MB) I tried with explorer and chrome. The far right hand of the row shows a green circle with a pie sliver which eventually disappears. The end result is no file gets loaded.
-
How to automate putting rows (based on conditions) of one sheet to a second sheet?
Hi, My sheet 1 has a structure with column 1, 2, and 3. My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5. Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2. Once sheet 2 is updated, I…
-
Conditional Formatting - Not working for updates / new cells
All of a sudden conditional formatting (colors) of cells when a specific list option is selected on a cell update or when a new row + cell is created. The conditional formatting rules are working for existing cells, but not for above. I've tried deleting the rules and re-creating them, clearing formatting in the column,…
-
Smartsheet and the Elusive Roadmap
Dear Smartsheet users, A few months ago, we made the decision to remove our public roadmap, which has caused frustration for many of you, particularly in our Smartsheet Community. We removed the roadmap for a few reasons - as priorities and resources change, we couldn’t give the expectation that the roadmap was set in…
