-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…
-
Incorrect argument set error message on countif formula
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
-
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…
