Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See att…
I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other. I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID…
I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for …
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here …
Hi all - First Discussion here. I am trying to use a formula that will populate a cell with "Not Started", "In Progress" or "Completed" based on the condition of eight cells in the same row have data …
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresp…
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the g…
Is there a way in data matrix to do a formula to count the the number of lines with a due date today to 30 days out? I am trying to see item that will hit in the future.
I am trying to create a complex schedule. I have multiple tasks that feed into two different predecessors but only one is recognized. Is there way for these tasks to both be recognized?
Hi I'm relatively new to SmartSheet and have a question. I have a set where each row represents a requirement. Each requirement may impact multiple systems. Since I'm unable to select multiple entries…