-
count values
HI, I have a form with checklist info for different types(Type 1 , Type 2), also in the form i specified minimum nr of selection for each types. After submission i want to check whether submitted info has the valid nr of selection r not Ex)For Type 1 person has to select minimum 1 checkbox For Type 2 person has to select…
-
Using Forms as an Trigger Input to a Smartsheet
Situation: Users want to use the Form as input to update the smartsheet (and also minimize cell overwrites or delete errors that come with users entering data manually in a sheet...). Idea: Create a Form in the smartsheet , use an column (Checkbox = Checked) on the Form to generate a cell with new data. Create a workflow…
-
COUNTIF, Cross Sheet, Multiple Contacts
I am counting the number of times a contact is referenced in the Assigned column, cross sheet. There can be multiple contacts listed on each row but I am just looking for a total count of the number of times an individual is listed. This is the formula I have, but returns unparseable. =COUNTIF({Internal Comms Intake Range…
-
Pre-populate formula form submission
I have developed a form that reports data back into a smartsheet when submitted. I need to apply formulas to the data in the SmarSheet. How do I prepopulate the SmartSheet with the formula's so it outputs the calculation in the sheet? Currently each time data is submitted from the form it creates a fresh line without the…
-
Cannot delete files from reports
We regularly delete files from the attachment column, a very important function of our process. As of today, it stopped working and the "Delete" function is grayed out. See attached. We can only delete from the sheet which is only a temporary workaround and not everyone has access to the sheet. Is anyone else experiencing…
-
Remove everything to the right of a character
Hi, I've searched the forum, but can't seem to find a solution. I have a series of domain names all different length. Some of them have subdomains, some don't. I need to automatically remove the subdomain text. Examples: Domain 1: thisisadomain.com/ = no issue Domain 2: thisisanewdomain.com/en = I want to remove everything…
-
Formula INDEX/COLLECT CLIENT VALUE by MONTH
=INDEX(COLLECT({Sales Pipeline Range 1}, {Sales Pipeline Range 3}, @cell = [Account Name]@row, (SUMF{Sales Pipeline Range 6}, MONTH(@cell) = 1)) I want a formula that recognises on a referenced sheet a client name, and totals the value by month. On the reporting sheet I have a table with a column for [Account Name], which…
-
Conditional Drop-down list columns
Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list. Say…
-
How can you sum a column with blanks cells
I am taking the sum of a Column from another sheet but it has blank cells please help me to overcome this problem...
-
Creating Formula to COUNTIFS two referenced columns from another sheet.
I'm attempting to create a formula that COUNTIFS two columns from a referenced sheet and am having no luck. Here are the two I've tried: =COUNTIFS({Start Date}, 0, AND({Not Applicable}, 0)) Error - #Incorrect Argument Set =COUNTIFS({Start Date}, 0, AND({Not Applicable}, 0)) Ends in a total of 0 The 0 isn't a true result.…
