-
Parent and Child Status Formula
Hi, I'm hoping to create a Formula in my parent row to state if both child row's marked as complete then Parent row will automatically mark as Complete. Is this possible? Thanks!
-
Getting a date when the status cell changed to a certain symbol
Record a date automation has been set up, which is fine for lines going forward, but what about the older lines? I want to set a date column where it looks at a row, where that row is a tick symbol, give me the date that it changed to the tick symbol The information is there in the cell history, but I can't link to the…
-
$ Absolute Date in Formula
Hi all, I have tried to create a formula as below, for a COUNTIFS the name is [Column X] 1, and the date is [Date Column] 1, but it is not working. Can anyone advise please? =COUNTIFS({Date Received}, =(DATE, Date@row), {Case Owner}, $[Column X]$1) Also tried: =COUNTIFS({Date Received}, =(DATE, [Date] 4), {Case Owner},…
-
How do you delete a conversation
I have started to use conversation / comments on my worksheets but when I have actioned the conversation / comments I am looking at how you would delete that complete conversation is one go. I can see you can delete individual comments but I am looking at removing the conversation completely with just one click. Is this…
-
How to check Finish date and %Complete to determine RYG symbol?
Hi Expert, Seeking advice how can I come out with a multi-condition formula from 2 columns with below criteria? Say I have a column name %Complete and another column - Finish Date If %Complete not 100% and Finish Date is smaller than today(), show Red symbol If Finish Date is larger than today(), show Green symbol If Today…
-
Need help on this. Assign no symbol automatically if Status is blank. Thanks
-
Calculation only if the field is not blank
I would like to conduct a simple division calculation, but only if the fields are not blank or if there is data in the fields. Because if there is no data in the field, then the division comes back as "#Divide by Zero". How can I avoid that? =([# of Ambient device installed]@row * 100) / [# of Ambient device scoped]@row…
-
sum dollars between date ranges
How do I sum dollars between 2 date ranges? sum = invoice amount if date on invoice is greater than date and less another date
-
Automate formula
Is there a formula that can do the picture below.... the Blue unlined column is provided in the form request, The Black underline column needs to recognise the contract id, then find the last V number allocated and allocated the next number.... so that the Red underlined column, when joined creates the variation ID…
-
Does Not Contain
I am looking to write a formula which says IF A1="removed" AND A2 Does not contain "ABC", "true","" What is the correct syntax for "does not contain" in this case? (I just can't get the typical "<>*ABC*" to work as part of a logic expression in Smartsheet. Thank you!