-
Working on formula to return the value of the NEXT CHILD row in PARENT column
I have a column called Project with a PARENT row called PROJECT 1. I am looking for a formula to use in another column (WHATS NEXT) that will return the value of the next CHILD row, until there are not more CHILDREN. Appreciate any insight on this. Seems like it would be simple but I don't want to COUNT the values I want…
-
Help with RYG Balls - Looking for an Average
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that has linked in RYG balls for health from another sheet. There are three sections, with…
-
Combining Multiple If(And( Statements
Hello, I'm trying to create a formula that will look at a language, the agency, and the status and fill in $ amount. I have written six different formulas that all work but when I try to combine them I get the error message, incorrect argument set. Here are the formulas: Sign Language - BY =IF(STATUS@row = "", "",…
-
Can Smartsheet enter a date automatically based on a progress update
Is there a formula that would allow Smartsheet to automatically enter the current date in a separate column when a drop-down choice in another column is selected. For example, when the Progress column is updated (through the drop-down) to "Assigned", can a separate column called DateAssigned be auto-populated with the…
-
Red Flag for overdue tasks
Hi, I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great. BUT.... It now red flags every row that doesn't have a date in yes which is an issue as we are using a project…
-
How do I create the formula I need? Dummy version
I used the formula =sum(qty1 * cost1) to get my total cost. I copied that formula down my total cost column and have a bunch of blank rows showing $0.00. How do I adjust my formula to leave empty rows blank?
-
COUNTIF with AND or COUNTIFS --> Not sure how to make this work; neither formula I tried is working
=COUNTIF(AND({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"])) =COUNTIFS(({2020-2021 Goal, Budget, and Performance Ti Range 2},"Budget",[{2020-2021 Goal, Budget, and Performance Ti Range 1},"Complete"]))
-
IFERROR Problems
I am trying to enter a formula that returns a 1 or 0 if the word "accepted" is in a reference cell. I am ultimately trying to run this formula for 3 separate cells, and if the sum of those cells is 3, then the general status column would turn to "Complete" and Health would turn to Green. Here is the formula I found, but it…
-
How can I improve/automate my workflow?
I currently have a sheet with Smartsheet Licensed Users in our company, we want to check the last time each user logged in to Smartsheet so that if we think they do not require a license we can remove it from their account. I currently do this by generating a User List Report in the User Management section of the Admin…
-
Multipart Average Question (With Criteria)
I am struggling to put together a multiple part formula that only does the average of a column if certain factors are met. I want to take the average number in column [NetDays] only if done is check and the row in column [Event Location] includes the word ABC. If possible only for events within the last 365 days This is…
