I have two Smartsheet's. The First Smartsheet contains all the original data. The Second Smartsheet will contain unique values from one of the columns (the column with a 1 in the IDUn... column). In t…
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 betwee…
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/o…
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…
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 w…
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 t…
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 …
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 …
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 questio…
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…
