-
FORMULA
If we already completed the row task and it's marked complete, it will automatically change "Balance to Bill row" to 0. If not completed I want the cell to have the formula of Project amount minus QTY Billed so they can get the pending balance. Keeps coming up Unparseable. See attachment. Thank you.
-
Summary Field, Date Within Range using SUMIFS
Hi, I am trying to use the following SUMIFS formula but I receive a "#INVALID OPERATION" error when trying to create a Sheet Summary Field using the formula. =SUMIFS(Hours:Hours, Status:Status, "Confirmed", FinishDate:FinishDate, >=12/10/2021) However, if I remove the ">=" and just use the date 12/10/2021 I do not get the…
-
formular syntax code editor
Hi all, I have some complex and long formulas in my sheet wit a lot of brackets. Do you know any syntax editor which I can use to document and analyse the formulas? Should have highlighting for opening and closing brackets etc. Thanks
-
IF Function to return Yes or No depending on difference between two dates.
Hello, I have two date columns; [First Date of Absence] and [Start Date]. I am trying to write a formula that returns "YES" if the difference between [First Date of Absence] and [Start Date] is less than or equal to 182 and returns "NO" if the difference between [First Date of Absence] and [Start Date] is more than than…
-
Am unable to retrieve Dates from one smartsheet to other
While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value
-
Sum of expenses of child rows in a formula row
Hi I have a sheet wherein a column contains all the expenses that is basically generated from the sum of other cells in the same row. This row is indented and I wanted to know if I could have the total of this in the parent of this row. Like the way it could be done in a pivot table. The formula in the column is applied as…
-
How to implement default highlight color in to field name
Hello, At present Smartsheet providing highlight changes for recent updates. Is it possible to add a column/field to indicate the recent changes col name in that field.? For example I want to see all the recent changes for the past 2 days in the new column/field it will show this particular row Col-B and Col-D was updated…
-
Nested CountIFS
Hello, I am stumped! I am trying to raise a flag when one cell is blank and 2 other cells match another row. In the example below, the first 2 rows should not be flagged because on is G8 and one is G9 in the Core Program column. The yellow rows should be flagged because none have a deletion date and the Core…
-
If/Then type formula
I have three percentages that are fed in a sheet summary. I can write this formula in the same sheet summary so there is no reason for cross sheet references. I need to write a formula that calculates the median of the three percentages. The only issue is that some of the percentages based upon the goals are beyond 100%.…
-
Employee Pulse Survey Template Set Formula Question
Hello I downloaded the template set for the employee pulse survey when I customized it, the formula to score the questions got erased. Does anyone have the the formula for the helper columns to assign a number next to the survey result? For example neutral should show 3 in the locked column. Thank you!