-
Re-submit for approval
I'm trying to work out a workflow that allows someone to re-submit for approval. I'm not sure how to record an update to a previous denial. Sequence Request submitted-> Approval Request to VP VP Declines-> Notification sent to requestor Requestor updates request (existing request in sheet) -> here's where I lose the…
-
Formula for counting in two separate columns
I'm trying to count the number of "yes" responses from one column using the range of a second column titled "Month/Year". I entered the following formula but the value returned was "0". =COUNTIF([Month/Year]:[Month/Year], "April 2022" + COUNTIF([Action Plan Compliance]:[Action Plan Compliance], "Yes")) I would like to use…
-
How to Find the Furthest Status
I have 2 sheets. 1 with all my active job orders, 1 with all active job applications. I want to create a column on the job report to represent the furthest active application Example I have a job called "Accountant" on the Job Order sheet. The ID# is 1234 On the application report there are five applications with a Job ID…
-
Multiple If Statements
Nested formulas and I are not friends. This works without putting more than one statement in here, what am I doing wrong and with multiple statements? =IF(OR([How many xyz]@row = "0-3 xyz", "$50-100K")), IF(OR([xyz?]@row = "4-10 xyz", "100-300K")))
-
Formula question
I am struggling with the formula. I need to pull the info from all the cells that contain the "ITEM" and give me the total number. Some cells have multiple items, so when i use the COUNTIFS formula it does not pull the info from the cells with multiple items in it. What formula should I use? I need to take into account…
-
Hello,
I am currently working on a digital performance evaluation. I have created a smartsheet with employees names, supervisor email, 30 day review date, 60 day review date, and 90 day review date. I have created a smartsheet survey for the employee to complete and a survey(evaluation) for the supervisor to complete. I would…
-
Formula Question
Hello, I'm trying to create a formula in Sheet Summary that counts the number of "yes's" within one column based on the Month/Year of a different column. My current formula is as follows but returns "0" for a value: =COUNTIF([Month/Year]:[Month/Year], "April 2022" + COUNTIF([Action Plan Compliance]:[Action Plan…
-
Can I restrict edits to a specific column until a resource is assigned?
I am working on a sheet that contains Maintenance tickets (each row is a ticket) and would like to make it that the status of the ticket ("Status" column) cannot be changed from to "Complete" until a resource has been assigned to the row. Is this functionality possible?
-
COUNTIF with date range and another critieria
Hi, I'm trying to count the number of rows which have a 60-day opt-out window between x and y and where the "Monthly DataCor Revenue" is blank. This formula works (y'all helped me with this): =COUNTIFS({Lite 60 day opt out}, AND(@cell >= DATE(2022, 8, 1), @cell <= DATE(2022, 8, 31))) but I cannot get an answer when I add…
-
How can I create a function that separates a string of words separated by commas into rows?
=JOIN(COLLECT([column1]:[column1], [column1]:[column1], ISTEXT(@cell), [column2]:[column2], =""), ", "). Right now, I have this function in my sheet summary to concatenate all strings that have text in column1 and has no text in column2. The output it gives me looks something like "task1, task2, task3, task4, task5, task6,…