-
Linking External Sheets for Conditional Formatting
I am currently working on conditional formatting for a spreadsheet that connects to several spreadsheets. We have a Master Log (spreadsheet) that pulls project dates from multiple Project Schedules (Gantts) so we can keep track of project timelines of milestones. We have roughly 45 fields. 17 fields are linked to Project…
-
Multiple approvals process
I'm creating tracking for a change process through various departments. What I need after project submission into Smartsheet is: Team 1 - intake, review, notes and approval (either approved - no comments, approved with comments, or hold - with comments) Teams 2-15 - same as above No one team's approval is subject to any…
-
Using Smartsheet Template "Project Issues Log"
The Product Issues Log is a template from the Creating Risk and Issues log training. This template is supposed to automatically move an item from the Open area of the sheet to the lower closed area when it is closed. I know there is something that has to do with the formatting of the issue in the description column that…
-
Introducing baselines for project management, available now!
Hi Community, We are excited to announce the launch of baselines - a fixed reference point in time to measure and compare a project’s progress to completion. Capturing and comparing variances between the current actual schedule and the originally planned schedule is essential for tracking any deviations and allows project…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Keep Health Status Formula When New Row Created
I am really close getting my health status formula that is based on both Status and Date to work. I need the formula to stay when a new row is added. I also want the status to be GREEN with DUE DATE = TODAY. Here is what I am trying to have happen If the DUE DATE is in the past turn the health symbol "Red" If the DUE DATE…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
-
Counting Cells that contain text
Good Afternoon, I'm trying to add columns that only contain text. I have a column where the users insert "issues" that they have with that particular line item. At the bottom of the sheet, I need to have a running total of how many issues are listed (and then make a graph) so I am trying to make a formula counting blank…
-
COUNTIF by MONTH in Sheet Summary Field
Hello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in a column and then use the Countif formula in the Sheet Summary field (ex: To…
