-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
-
Nested If with Multiple Conditions Automation for Project Management
Hi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started") I just…
-
Best way of Counting a given number of States
Hi there, I am trying to have a graph display the count of some things across multiple sheets (~40), as shown in the screenshot. The only way I could think of for now was to get the data by cell linking and doing some calculations on it in an extra sheet. As it turns out now, doing all of this "manually" for multiple…
-
Gantt View Timeline Zoom
I want to be able to view my gantt chart more zoomed in. Is it possible for me to have my primary headings as days and secondary as hours? Or is the furthest you can zoom in weeks and days?
-
Sharing Report to non-licensed users
HI, I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users. Before we signed up to the paid account this was an option. Thanks, David
-
Automatically update form link when creating new folders
Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and does not change when I copy the folder template and make a new project. Is there a way…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Automatic Move Row and External Sheet References
I am having issues with the Automatic move row function and external sheet references. It doesnt seem that the automation will trigger if the formula needs to look up a value from a different sheet. Proofing is not turn on for this sheet. See screenshot for the formula Automation: If cell= "a number", then move to another…
-
Automatically alert when project goes beyond an install date
Hi, We have multiple (50+) projects and once the project commences an install date with the customer is fixed. I have set this up in smartsheet, to have the install with no prior dependancies. What I wont to do is set up an alert when the project build is after the agreed install date. Any ideas on how I can do this?…