-
Need help please
Hi wondering if anyone can help me I have set up a smartsheet that my staff fill in via the form each day (example 1) for the amount of jobs they have completed. I created a summary sheet (example 3) which gives a count of all completed which feeds into a Dashboard, but I need to get the number for each staff member of…
-
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)),…
-
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…
-
Can USER interact with a Dashboard to, for example, specify dates?
I want to create ONE dashboard to let user view project status for a given time period... but ideally we can have the user select/enter a start and end date to view data by... how? can this be done? Or do i have to force-feed the user what I want them to see only? Thanks!
-
Calculating available hours based on multi-select dropdown
Hey all, I'm working on building out a scheduler for people; on the signup form, they have options like: Monday 8a - 12p Monday 12p - 4p Monday 4p - 7p ...and so on through Friday, plus some Sat/Sun weekend shifts. What I'd like to do is calculate the Total Available Hours and use that as a reference point to pull from…
-
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…
-
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.…
-
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…
-
I want a blank cell to return a symbol in another cell
This is a pretty basic question that I'm sure has been asked before, but I'm having trouble finding an answer. I'm using the below formula, but I need to add an additional rule so that if the Loaded cell is blank, it would return the "Hold" symbol. I've tried some variations of ISBLANK, but haven't gotten any to work yet.…
