-
Is there a formula to add check boxes from a row?
I have a form, where the form user is checking click boxes. I am trying to total the number of check boxes so I can total their entry quickly. Is this possible? I have tried adding columns to give the check boxes a value, then tried counting those added columns. I am at a loss, and feeling like it can not do what I am…
-
Date Formula to return following Monday or Wednesday
Hi everyone, I need help with another date formula. For this one, we have a system entry that needs to be done which will trigger the "Expected live date". I currently have a "Task" column and a "Due Date" column. Here's how it should work but realize the timing may be impossible to capture... 1) If the system entry was…
-
Exclude one child row in the parent row update
I have created sheets to track critical HR tasks that are performed on regular basis. All is working as expected (thanks to help from a few of you) but this morning was thrown a curve ball. USE CASE: This one tasks has ten check points in process. Of the ten, the last step is only late 4 business days after the previous…
-
Formula to Auto assigned Id_Number as Input in Sheet
What Formula should I used get desired JV number output -> Here In Sheet I what to get out similar as shown in JV Number column, Point to be note number id in JV number should be assign as per entry in sheet. 1) So Here in variation# column the entry is against variation num. VAR-0012814 so number assign to it should be…
-
Getting #INVALID VALUE error with INDEX/COLLECT function
I'm trying to pull distinct values from a subset of a range. I'm using the following formula: =INDEX(DISTINCT(COLLECT({Subject}, {Site Number}, {Metadata Site Number})), [Unique ID]@row, 0) I'm looking to generate a list of distinct values that are for a specific subject (patient) that's at a specific site, which is…
-
Month, Day, Year Date Conversion to MM/DD/YY?
Good afternoon, I'm working with a sheet where the data is imported from Excel, and the Date column is actually the primary column on the Smartsheet tracker. Given that it's the primary, it's obviously not a date column, and since it's imported, it's being imported in this format: March 4, 2024 5:10pm Now, I created a…
-
Setting an entire Project Sheet to On Hold
Hi all, I'm sure someone has encountered this but I'm curious if anyone has done anything with setting an entire project "On Hold" so that it reflects in the rollup sheets/dashboards. For reference, we are using the PMO template to base our projects off of. What we would like to be able to do is put a new row in at the…
-
How do I get my formula to include the leading 0 in the beginning of all numbers?
Currently I am running the formula below to get a set of 8 digits (including a leading 0) to separate it from it from the Site Name. The formula is currently taking the leading 0s out of all of the numbers I am trying to get into my new column, but other than that working fine. How do I get it to include the leading 0 plus…
-
Is there a 'Remove Duplicates' feature?
I am attempting to remove duplicate rows in a sheet but can't find an easy way to do it. I used the AI function to generate a formula for it and I got the above result. Just wondering if there is a feature to remove duplicates or if there may be in the future?
-
Prepopulate Form for Update Request
We use forms to get information from our colleagues and we would want to send them a form prepopulated by their inputs so they can update the information if there are any changes. This would be very useful if we can automate the process and make the items mandatory
