-
Sum if there is any text in a range
I'd like to make a sum total at the bottom of a sheet in which I add only amounts if the cell in the same row has any text. I tried using this formula: =SUMIF(Location221:Location90, >0.01, [List Price]221:[List Price]90) , but it only works if there are numbers. Any help would be appreciated!
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Mark child if Parent meets criteria
Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2,…
-
Sum of Parents
I keep track of pending transactions in a real estate office, and have each month as a parent and the closings scheduled as children under the correct month. On the parent row of each month I've got totals showing for the children. This all works great. What I can't figure out is how to total the parents. At the bottom of…
-
Stop Counting NETWORKDAY after Done Box is checked
Hi everyone, I'm hoping this is easy to read, it is hard to explain. I am trying to STOP counting days from commencement date of a project once the DONE box is checked. I have managed to make it work without using NETWORKDAY, using this formula =IF(Done1 = 1, [Last Updated]1 - [Commencement Date]1, TODAY() - [Commencement…
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
using Harvey ball status to drive a formula
Hi, Is there a way to use the harvey ball status to drive a formula? Here's an example of what I was able to achieve in excel but cannot replicate in Smart Sheet. =If(HarveyBall = "Full",date-today(),"") Result in excel, I get blank if result is true Result in SmartSheet, I get #Unparseable Observation is that the…
-
Help with a formula: Do not run formula if cell is blank
Rookie here -- I'm hoping to get some help with a formula issue. I am trying to flag the "Attn" column if "Days Until Due" is less than 120. However, I don't want the "Attn" column to flag if the cell is blank. I currently have this formula configured for the Attn column, which has the flag symbol: =IF([Days Until Due]1 <…
-
Formula for last 24 hours
Hello my friends - I need to create a formula to find any new rows added to a sheet in the last 24 hours. My created on system column is added. We currently are using the TODAY function, however, that only captures those added today, which leaves out a great deal of data when generating a report in the early a.m. hours. If…
-
Date validation on Web Form
Is there a way to validate a date before submitting a form. The Use-case is: We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We want to add a condition on the form; so, they can't select an Event day within a week, before they submit the form. Thanks J
