-
IF Formula questions
Apologies in advance, this is a real newbie questions. I am trying to create an IF formula which checks if the value of column Chargeable is TRUE it should then divide the value in Quantity cell by 7 and store in the formula cell. If Chargeable != true then set the value in the formula cell to zero. Following is what I…
-
How can I find a position of a character in a string?
Hi all - I'm trying to find a position of a character within a string, which in theory seems simple - just use the FIND() function. What I'm struggling with is when there are multiple instances of the value, and I want to start at the 4th instance (for an example) of it. Here's an example of the String I'm trying to parse:…
-
Can you help me simply this formula. I think I can use "And" and "Or', I just dont know how.
=IF(sum( COUNTIFS({ML student status}, "No",{ML status}, "Qualified occupied"), COUNTIFS({ML student status}, "No",{ML status}, "UU Pre-Approved by Compliance"), COUNTIFS({ML student status}, "No",{ML status}, "QV Pre-Approved by Compliance"), COUNTIFS({ML student status}, "No",{ML status}, "Unit is in Rehab"),…
-
Formula Issue
I have a form where I am collecting data on a metric sheet to translate to a dashboard for a group. I have two questions: I am using =COUNTIFS to collect the answer that is considered a violation + the date of the line, and am separating it out by months. When all the answers that are violations are "No", my formula works…
-
Update TODAY() function automatically improvements
Hello SS Community, I have been using the required automation to update my sheets automatically since I am using the TODAY() function on my rows. The current setup I have is to check an unchecked box and vice versa. Other solutions found here:…
-
Formula to count two different values in the same column
I'm trying to create a summary field formula to count two different values in the same column. The formula seems to work, but it returns a value of "0" which I know is not correct. =COUNTIFS(PMActivity:PMActivity, "303", PMActivity:PMActivity, "307") Hoping someone can point out where I've gone wrong on this one. Thank you…
-
How to use COUNTIFS + CONTAINS in one formula?
Hello everyone, Already grateful for your assistance in advance. I'm having some trouble coming up with a formula that can determine how often a multiple-choice topic appears in a column. I've used the COUNTIFS function and it worked well on the column with single-choice topics. But when I use the formula CONTAINS, it…
-
Formula based on created time foiled by users in different time zones
I created a formula that looks at the created time and date and checks a box if the hour is after a certain time if the day is a certain date. When the box gets checked, it means the entry was made late, and an approval workflow kicks off to managers to review and approve the entry. The created time deadline is CST based.…
-
How to have Parent field Status update according to multiple Children field Status?
Hello all, I'm relatively new to smartsheet and excel and was hoping to get some help automating part of my sheet. I also have a bad habit of going about things the most complicated way possible, so there may be a much simpler way to accomplish this. The columns involved are: Status(TBD, Complete, On Schedule, Past Due),…
-
Setting Task Due Dates Based on Project Due Date (Retroactively)
I need to create a sheet/template where the due dates of tasks are based on the project's due date (i.e., I want to "back into" the project due date). I assume formulas or helper columns might be necessary to accomplish this (e.g., =Projectt_Due_Date-90, etc.), but I can't wrap my head around how to do this using…