-
Help with formula that sums child rows unless a condition is met
Hi, I'm looking for help writing a formula for the cell highlighted in Red in the screenshot below. I'd like it to SUM(CHILDREN()) unless one of the child rows contains "SELECT CURRENCY", in which case I'd like it to return "ERROR". Any ideas how to write this formula? Thanks!
-
Nested IF with AND and OR
Is there a good "Nested If" explainer out there? I've gone through many sample formulas and I have written simple formulas for each line of what I need to do, but I still find myself stumbling when I try to next them together. It seems there should be a formula tutorial out there that would walk you through the next…
-
Need help with IF / CONTAINS / AND
Hello, Here is my current formula. It accepts, however the first row generates a "#CIRCULAR" error and then the rest of the rows become "#Blocked". Essentially I want the rows to sum some values, and if the row contains "Phase Total," I want it to sum the rows above (single column), to give the totals. I have two helper…
-
Too many links - but same as lots of other sheets
Hi I've created a batch of toolkits for projects. All absolutely fine and all identical until now. I'm getting an error message to tell me that there are too many links, but the sheet I'm linking from and to is absolutely identical to 10 others that I've created without any problems. I've deleted the sheets, re-named them…
-
How do I send a notification of training expiring to other contacts?
I have a sheet set up tracking the completion and expiration date of training for personnel. Each row has the contact info for the person it relates to. How do I send a notification to that person when their training is within 30 days of expiration? I've tried several workflows, and it keeps sending a notification with ALL…
-
Formula to populate just the first row of data in another sheet
I'm trying to write a formula to populate data from one sheet to another but I only want the top row of data to populate and then update when the 1st row changes. I have a Submission Form sheet that gather data from a form, when a new form is submitted it will be at the top of the sheet. I want that top row of data to auto…
-
How to make parents equal to the children list in a drop down menu
Hi everyone, I have been struggling for a while with this formula. I'm trying to have the parents populated automatically to be equal to the list of children in a drop down menu, without repetition if the same instance is repeated twice in the children. In the picture below I'm trying with =JOIN(DISTINCT(CHILDREN()), " ").…
-
Formula that will pull the most up to date information from
Hello I have a sheet that gets new entries every month and each month, the status of the project is calculated and may update. I have another sheet that holds the project information and it needs to show the most up to date status of the project. I was wondering if that is possible to do by a formula that will take the…
-
Symbol to reflect variance from previous day
I am trying to create a formula where If the number from today is equal to the previous day, then the symbol will be yellow arrow, if it is less than the day before, it will be a green arrow and if it is greater than the day before, the arrow will be red. Any ideas?
-
Sum items selected in a drop down with cost on another sheet.
I am trying to create column that will return the total cost of item selected in a multi item drop down list. The price of the items are on another Smartsheet. I want the other sheet to stay separate so that it will be easy to change the cost later down the road without having to restructure the formula. Basically I have a…
