Hi I would appreciae some help please
I need a formula the will total the number of enquiries in a column named status that has several other options in the multi select box but from 31/12/20 as opposed to giving me the total for the last 5 years!
Are the values in the multi-select integers or strings? I am trying to understand if you need to sum values if they fall within a date range or if you are trying to count the number of times a selection appears within a date range. A sample table screenshot would be helpful.
Thanks for picking this up I will try and capture one later when back at work but its basically a column named status with a lot of options in it that can be selected that shows the progress of enquiries we get. what i want to do is sum the total number of times from 31/12/20 that the option "enquiry" but not count other selected options,once i can get that to work i can then substitue the word enquiry for other options to give me an overview from 31/12 - today etc.
Thanks for your help
Further to my last post this formula works fine for all entrys but i want it to only give me a total from 31/12/20 i.e. year to date 2021
=COUNTIFS(Status:Status, CONTAINS("enquiry", @cell))
any help much appreciated
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.