-
Connecting sheets
I have a large smartsheet project management based, it has a lot of data in it. I wanted to make another sheet to use as a budget tracking sheet but I want the costs per item to automatically upload from the original document. I have tried Vlookups, index with match, I am pretty lost in this search. I just want to layout a…
-
Formula Help
Hi, I have 6 status columns (harvey ball) that are used to show that status of 4 separate steps to complete work. I then have a 5th column (dropdown currently) that I would like to be automated with a formula to give the overall status of the work being completed. If all columns are green = "Complete" If any column is…
-
Disable auto refresh?
I want to make a dashboard that pulls data from another sheet, but I only want to update it once a week. Is there any way to delay the auto refresh?
-
Notify Dependent Task Assignee That Predecessor Task Has Been Completed
Here's the setup: I'm trying to get team members to use Smartsheet more. One of the ways I'd like them to use it, is to get them to mark a task as complete once it's been completed instead of me chasing them around and asking them if they've completed the task and then checking it off for them. I'd also like to automate…
-
How identify where actual lag time is different from standard lag time?
Need a way to identify tasks on my workplan where the actual lag time is different from the standard lag time. My workplan includes: 1. Predecessor column (includes predecessor with +/- lag) 2. A separate text column "Standard Lag Time " Whenever the lag time needs to be changed the predecessor column is updated. The…
-
Average days returns 1 value if 0 and the average value if >0
I'm trying to have the value of a cell say same day in the event the average number of days is 0. I want to return the average number of days id greater than zero. Everytime I add an else statement it becomes unparsable. Here is what I have. =IF(AVG({Field Scheduler Test Range 1}), 0, "Same Day", (AVG({Field Scheduler Test…
-
Returning Task Name based on a MIN(COLLECT(range, criteria_range, criteria)) formula
I am trying to get the task name of the current milestone to populate a cell so I can use that cell in a dashboard. I have a helper column that counts the number of days until due, and can get the lowest number in the range that is >0, no problem. How can I return the Task Name of the row that I find my lowest number > 0?
-
Only perform calculation if cell is not blank
I have search the community and tried some stuff but have had no luck, pretty sure it is an easy fix. I have "todays" percentage cell subtracted from the previous day. however it is also calculating " tomorrows" date even though there is no data in the field. How can i have it calculate only when data is in the cell.
-
IfError Formula
Hello, I have the formula but would like to add the IfError to it to avoid the #DIVIDE BY ZERO - any suggestions? =[2018/2019 Sales]1 / [Square Feet]1
-
Sheet Summary COUNTIF
I'm having problems using the COUNTIF function in the new-ish sheet summary. Everytime I sort rows it changes the range. For example, in a summary text field I have =COUNTIF([Column A]1:[Column A]79, =0) After sorting by a column it becomes =COUNTIF([Column A]29:[Column A]43, =0). Or something similar. The sheet summary is…