-
Nested IF Statement
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue... =IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe…
-
Auto populate Percentage Complete
Hi, I have a "task" in my sheet which lasts for 3 months. Is there a way to autopopulate the percentage complete based purely on the time passed? It is not a measure of outputs / delivery but just showing how long an external resource is in place. For example, after 1 month, it would say 30% complete. Many thanks, Siobhan
-
Date Range Formula
Hello, I am having an issue when trying to return values like "FY22" based on a date range. What I need is that is the date is between FY 06/01/2021 and 05/31/2022 for it to return FY22, if not then x. I get #Invalid Operation, and I've tried many different ways. This is what I have now: =IF(AND([FY Eligible Date]@row >=…
-
Within an IF Formula, recognizing a date prior to.
Hello. I have created a formula to indicate the status of our project based on today's date and if it has met the date each phase is completed. =IF(TODAY() > Date82, "Operational", IF(TODAY() > Date77, "Pre-Operational", IF(TODAY() > Date72, "Under Construction", "In Development"))) The phases were put in reverse, to…
-
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…