-
Method to update field automatically (based on other field updates)
I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet. In my example I have a review process that sends multiple emails at once for review and approval. The reviewers each have a field that the indicate approved or rejected in. Once all of them have approved I…
-
RYG Balls
For this formula, I would like the RYG balls to be the result. Instead, I’m getting the word “Green” or “Red”. So the formula is working, but would like the balls and not the word.
-
If - Then - Else
I'm trying to create an If/Then/Else statement to determine if an employee is eligible for a pay increase. Essentially, the formula needs to say IF Mandatory Training Requirements Met = YES AND Corrective Action = NO THEN Eligible for Increase = YES ELSE Eligible for Increase = No Any thoughts on how to accomplish this?
-
Auto-fill is outdated
The conditions that formula auto-fill performs in are ridiculous (based on the row above/below). It's incredibly temperamental and not fit for purpose. Likewise if you copy a formula down a column, I'm experience the following problems: * When you add a new entry into the card view, it adds the result to the end of where…
-
NETDAYS #INVALID DATE TYPE
I can't figured out why #INVALID DATA TYPE auto fill when I haven't pick a date for the start and finish date. If I do have those fill out then the formula works fine but otherwise it just fill the duration cell with that error. I do have the duration column under Text/Number. The only thing that I can think about is that…
-
Formulas not adding as numbers
Hello, I am using the formula =IF(Status2 = [HIDE: Statuses]1, "15") to add a set percentage to a completed task when the box is checked. It works, but then when I go to SUM those numbers, they simply combine the numbers (as though they're text) rather than adding them together (see %Complete1 and %Complete4). How do I…
-
Comparing the most recent two quarters
Hi, I have sheet collecting total cost dollar figures as they are entered each quarter (over a three year period, so 12 quarters total) into another sheet. The accounting system is accrual based, so each quarter the dollar amount should/must increase. I'm trying to figure out a formula to automatically compare the most…
-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
SUMIFS Help Please
Hi, I need help for a simple formula. I emailed Smartsheet support a month ago but never got an answer. I want to total how much has been spent by budget type in a given year. Example types are Gardening or Security. Debit is the $ amount, and Year is 2019 in this case. Columns are: Type, Debit and year. Can anyone please…
-
Question on formula
I would like to add a check for blanks in the following formula using 2 date columns. My current formula is returning a "yes" when there are blank cells. I am using this for a KPI metric. =IF([KPI | Actual Sizing Completion]7 <= [KPI | Target Sizing Completion]7, "yes", "no") I have tried numerous combinations of ISBLANK,…