-
How to compare form responses with a list of emails?
Hi! I have created a survey/form and emailed it out. One of the survey questions asks participants to enter their email address. How can I compare their responses to the list of emails I sent the form to? I would like to create a report that shows who has responded and who has not based on the email addresses.
-
Determining Count of Items in a column based on Specific Dates
As the title suggests, I am trying to determine the number of Active Projects, based on status, on a monthly basis. I am not basing my logical expression based on a date criteria in a cell; I simply want to see: Active Projects (based on a status of: Not Started, In Progress, On Hold) Jan 01 to Jan 31 (as an example; would…
-
Countifs, Date Functions and Text Criteria
I am putting together two sets of formulas so I can capture the number of tasks within a certain year and month, and another set to see which of those are completed. My formula that works to capture the number of tasks is (in this example, January 2024: =COUNTIFS({GA Date}, IFERROR(MONTH(@cell), 0) = 1, {GA Date},…
-
Reminder automation
Hi! I'm trying to set up an automation for weekly reminders if certain conditions are met / not met, and from what I can tell everything has been entered correctly, yet when I run it to test it seems to fail. Any help is appreciated! Here's a description of the situation and what I have set up: Several farmers markets have…
-
Lookup with #NO MATCH error
I've used the Lookup formula to find hours per work order number. Until today, the formula reported "0" in the event the lookup value was not found. As of either Jan. 17 or 18 (today), it now reports "#NO MATCH" when the lookup value is not found. Did something change recently with the way this formula works?
-
Am I using the AVGW formula correctly? Can I make it a column formula?
Hi, I'm trying to calculate the weighted average for a survey question. The question asks if the person was satisfied with the learning program they attended. I want to have the score for this question for each program to identify the programs that were highly satisfactory, our "top rated" programs. I've created a Pivot…
-
Comparing the time contractors plan to work VS actual hours on a dashboard
Hello all -- I want a sheet which will be used for contractors to log their planned billable hours, their actual hours, and their planned time away for a given week. The spreadsheet will have multiple weeks in it, and contractors will fill it out for several weeks at a time (the planned hours and planned time away). As…
-
Forwarding Approval Requests
Hi All, I am developing a system that involves a large workflow of approvals. I have it set up so that the user selects a person for each approval to go to. However, I want to be able to have the person who receives the approval, be able to defer the approval to a superior if it is necessary. I found that forwarding an…
-
Summary formula vs Column formula: Incompatability issue?
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
-
Nested IF(OR statements column formula
Hello smartsheet Community! I'm trying to have a status column update based on three approval columns. There's several reasons why a row would be green ("Yes"), yellow ("Hold"), or red ("No"), so I'm trying to use nested IF(OR statements. It's possible I'm overcomplicating this and there's an easier way, any help is…
