-
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?…
-
Colour grading
Hi all, Is there any way that i could, based simply on ascending order of numbers, colour code a full column, as i have in the picture below? Thanks.
-
Every 2 Weeks Alert Not Working
I set up an alert that says send an alert every 2 weeks starting on Monday, Nov 4 @ 9 a.m., the condition is the status must be 'Open." However, it doesn't send. If I sent it to weekly, hourly, daily, it works but the every 2 weeks won't send. What am I doing wrong?