-
Having trouble with the duplicate formula and where to input.
I am trying to set-up a formula, so if there is a duplicate in the Family ID column, the box becomes checked in the Duplicate column. So far, during the searching I have done for other users with this same problem, I am still left with an error message each time. Is there a way to run the formula on the whole column, or do…
-
Counting Functions
I'm using this formula to calculate the number of inquiries received versus those who have not yet been resolved: =COUNTIF(AND(ISDATE([INQUIRY DATE SUBMISSION]1, "Cell contains a date", [DATE RESOLVED]1, "Cell doesn't contain a date")). What am I doing wrong? Please help! Thank you so much!
-
Help with Cross Sheet JOIN(COLLECT) formula
I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. From what I can tell I haven't removed any of the formula…
-
Index/Match Help
I have trying to create a formula so when we purchase materials which will be logged on my order list sheet, for a job using the Job reference from my job planner sheet. It will calculate the running cost of materials and bring it back to the material value column on my Planner. I have been trying the below formula but…
-
Validate Column Data Received in a Form
I have created a simple form to collect the following fields of data: First Name Last Name Email ID number Because a lot of times people are entering information into a form from a mobile device and sometimes have "fat fingers," I wanted to validate the ID column (with a list of users and IDs on another smartsheet). What…
-
Question on Counting days "If"
Hello, In my Smartsheet I have a status column that = "RESOLVED" or "IN PROGRESS" Each row has an "ENTRY" date and sometimes a "RESOLVED" date, if applicable. If a row is "IN PROGRESS" I want it to count the NETDAYS from today, but... If an row is marked "RESOLVED" I would like the NETDAYS function to stop counting.…
-
Nested IF Help
Hello, I have these columns: In a perfect world, when the status changes to RESOLVED, the date resolved would automatically populate. Since I can't do that without the use of something like Zapier, I'm trying to define a workaround using an additional column "Days to Resolve". Some issues have been resolved, but a…
-
Formula to check a box or to change status
Hi Two of my columns are Status (dropdown options) and Done(checkbox). I currently have an automated work flow sending out alerts if the Done box is not checked. I only want my users to have to change the Status column to "Complete" and then the Done box automatically get checked. I was trying this to no avail:…
-
Cake chart based on number of taks done and not done
Hi everyone I got column Chart counting . I would like to have formula there which put 1 if "done" column is checked and 0 if is unchecked. I need some column which count which task are closed and which are not to create chart. My idea was to add column Chart counting and take data from there. Many you have another better…
-
Sheet conditions
Hi, Is it possible to set up a condition in a Smartsheet where a person is allowed to enter a date in a cell only when a condition in the the same row is met? For example if Column 3 row 1 has a date then let a person enter a date in Column 4 row 2? If the column 3 row 1 date cell is blank then don't allow user to enter…
