-
"OR" function in formulas
Hello, I just tried this formula, basically I am trying to have certain conditions set, and would like to use an or function for the catch basin, grassed area and roadway function. =COUNTIFS({Environmental Incident Tracking Range 4}, "1", {Environmental Incident Tracking Range 5}, =(2020), {Environmental Incident Tracking…
-
count overdue dates and ignore blanks using countifs
So far I have this and spent 1/2 hour plus trying to understand isblank and error trapping in the forums but can't quite knit everything together. =countifs(cc:cc,"120802",[Due Date], <=TODAY) Background - cc column I want to show only 120802 and for the Due Date column only count those dates < today's date. My problem is…
-
Is there a way to make sure someone can only fill out a form once?
I need to send out a form to staff so they can sign up for an event. Is there a way to create the sheet or form so they can only fill out the form once? Thanks, Karen
-
IF formula with single select dropdown
I could use some help with the IF formula when trying to add a value to a single-select drop down. I am using percentage to track a customers completion of our program. I have a column labeled "Sleep Study" with the drop down options of Required, Not Required, Complete - records requested, Complete - records received. When…
-
Formula for COUNTIFS function with multiple criteria
Looking for help with my COUNTIFS formula for my sheet summary... I am trying to count all instances of the value "Mega" in the "Deal Size/SET Level of Support" column when the "Status:" column is any of the following "In Progress", "Proposal Presented", " Proposal Presented & Shortlisted to Presentation Stage",…
-
Linking cells - when new rows are added to source sheet do I have to manually update links
Hi all, We are reaching the referenced cell limit in our sheet so I have separate sheets to do the required formulas. To do this I have needed to link the "unique identifier" cells to the intermediate sheets so the formulas know what data to match (then use an index match back into the source sheet to populate the required…
-
collect multiple records data with one form
I need to collect tabular data (list of chemicals products used in their products with quantity and other info .. ) from several suppliers . Id like to use smartsheet forms which are open in the Internet . But I need to collect tabular data , ( which means filling multiple records of a smarsheet ) with one single form ..…
-
How to count green(or bold) cells only?
Hello, I`m trying to create formula for counting cells colored in green in same row. In excel I used macro for colorfunction but has no idea how to do it in smartsheet need smth like =sum ([col1]1:[col10]1) if format is the same as in a special cell Thanks!
-
I'd like to create a column that generates a number of working days between the finish date in a row
I'd like to create a column that generates a number of working days between the finish date in a row and today. So, if today is Sept 15, and a task is supposed to finish on September 18, the cell in the column would display "3". What formula should I use? Similarly, is there a variable in SmartSheet formulas to represent…
-
Sheet Summary won't count only rows with no ancestors
Can't seem to figure this one out. I would like to count rows that have a Status of 'Complete', and are not a child of another row. My formula is this: =COUNTIFS(Status:Status, "Completed", Status:Status, ANCESTORS() = 0) What am I missing? It keeps returning just zero. I've tried pointing the second range at the 'Task'…
