-
Project Completion %
Hi! I am pretty new to Smartsheet and am building my first project template. I've got tasks in rows 21-169 and I am trying to build a formula to calculate the total completion of the project, taking into account the durations set for each row. The rows are also indented into phases and milestones. Any help or direction is…
-
Formula reference in IF statement unparseable or invalid operation.
I have a column called [Limitation]. If that column has the value B1.3 in it, the [Reference] column should return "3", otherwise "NA". I am using =IF([Limitation]:[Limitation] = "B1.3", "3", "NA") It seems like it is right, but it's unparseable. Any ideas? I will add that =IF([Limitation]1="B1.3","3","NA") works just…
-
Referencing Another Sheet
Does anyone know a way to reference another sheet so that you can bring information in from one sheet to another? Looking to bring text from one column in a sheet into another sheet and can't figure out a way to do that. In excel you would simply just do "=" and then select the cell on another sheet. I tried using lower or…
-
Date formula - PastDue/Ontime/Ongoing or remain blank ?
Currently using a formula (which works) which states if a column is past due if posted after the target date. Hoping to get help with updating it so that if the date isn't filled in yet it will say "Ongoing" or remain blank. =IF(AND([Targeted End Date]@row < ([Actual End Date]@row), Status@row <> "Closed"), "Past Due", "On…
-
Helper Column not being recognised as a date
Hi, I'm using Data Shuffle to import a report generated from another system into an excel sheet into Smartsheets. However, on the date on the report also has a time stamp. Which Smartsheets doesn't like, so I've used a helper column to generate the date without the time stamp. By using the following formula:…
-
Formula Help
I have 2 columns. Annual Estimated Savings ($) Confidence (25%, 50%, 75%, 100%) I need a formula that will total the value from column 1 each time 25% is chosen etc. from the amounts in "Annual Estimated Savings"
-
combining cells for a report
Good afternoon. I am trying to combine information from a single row but multiple cells into a single cell on a report. I need this information to show as a list on the report. So for example my spread sheet has: I used a simple formula (=[Item 1]@row + " " + [Color 1]@row + "," + [Item 2]@row + " " + [Color 2]@row + "," +…
-
Hi All, I have a question about COUNTIFS()
The scenario: I am trying to count only the rows that meet two criteria. This sheet tracks requests for headcount by type and by year. So there are two columns among the data, one that states the year requested, and one that states the type requested. I have two ranges, one for each column in the formula. Each range only…
-
IF(Condition Check, Light) Question
I am somewhat a new user to SmartSheet and here is the formula that is confusing me for a while: =IF([Planned % Completion]@row - [Actual/Outlook % Completion]@row > 0.2, "Red", IF(AND([Planned % Completion]@row - [Actual/Outlook % Completion]@row >= 0.1, [Planned % Completion]@row - [Actual/Outlook % Completion]@row <=…
-
How to write formula that states how many open tasks a person has based on another field being blank
I am still learning Smartsheet and formulas so please bear with me lol... I am trying to show in the Sheet Summary report that counts the number of open tasks each one of our validation engineering techs have. Ideally I want to this information to be pulled from the column [Validation Tech/Engineer] and the # of open tasks…