-
Formula to place a text status based on completion of tasks
Hello, I haven't worked with formulas enough to get started with what I am needing. I have 3 tasks that need to happen, 'A', 'B', and 'C', before the job can be marked done. There is a checkbox column for each 'A', 'B', and 'C' showing if they are all needed. Regardless of whether or not they are all needed, they need to…
-
Combining IF AND NOT ISBLANK Function
Hi there, Can anyone tell me what is wrong with my function below? =IF(AND(ISBLANK([Date Submitted to SS]@row), ISBLANK([Date Enter/Update to RPM]@row)), "Empty", IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)), ISBLANK([Date Enter/Update to RPM]@row)), "Half")),IF(AND(NOT(ISBLANK([Date Submitted to SS]@row)),…
-
If Count is Zero leave blank or --
I have a formula that takes information from different sheets and outputs a count. I would like to replace and fields with a 0 count with a double dash (--). I got the formula working for fields that have a Zero, but when I use the same formula in a field with another number (Ex. 1, 12, 13, etc) it leaves the field blank…
-
Check Box Question
Can you make a requirement to fill out specific boxes before you are able to check the checkbox? So basically you can't check the box unless Column/Row A1 -- B19 -- and M24?
-
Index and Match
I am trying to use Index and Match in place of Vlookup and I find that when I am trying to update the reference all index and match formula's get updated to the most updated reference. Example: I am trying to pick up start and end date for one record. When I index and match reference to start, the end date also becomes the…
-
How to use SUMIF and FIND Function while not including parent cells?
This question has been asked but hasn't been answered how I am trying to use the formula. I am trying to sum a column based on various criteria while not including the parent rows because I don't want the numbers duplicated. This formula is in a cell on a different sheet than where the data originates so I am using…
-
Auto formula Sum is generating a 0 when no data is present yet
I have a column with an autogenerated formula looking at turnaround time. Essential day completion minus day start. Somethings are finished the day of and have a turnaround time of 0 days which is great for us, however, for rows that do not have a finish date yet it is auto generating a 0 instead of what should be a blank.…
-
Flagging bad phone numbers
Hello! I've been reading around and I feel like I'm missing something with my formula: =IF(OR(NOT(ISNUMBER([Phone Number]@row))), [Phone Number]@row < 1000000000, [Phone Number]@row > 9999999999, 1, "") Basically, I want a checkbox to tick if any of the following happens: Any characters are added It has fewer than 10…
-
Formula not returning correct data
Hello, I'm trying to count the number of projects by project owner and when it was completed. Below is my formula. It is returning data, but not the correct data. I'm sourcing from another Smartsheet. How can this be adjusted to work properly? =COUNTIFS({Completed Project Owner}, [Project Owner 2]1, {Completed Projects…
-
Workflow to run on a specific day of the month based on a number that's put into a cell...
I'm trying to set up a workflow that will run monthly based on the number of the day of month that is entered into a cell. So if "5" is entered into that cell, the workflow will run on Jan 5, Feb 5, Mar 5..... If 10 was entered, it will run monthly on the tenth. Every row will have a different number in it. I really don't…