-
How to utilize a Checkbox with multiple Options
Hi, I know this is really simple but clearly it is Friday and my brain is no longer working. I am trying to have a checkbox automatically check if the Finding is "Non-Compliant" or "Partially Compliant". I am able to get the functions to work when just choosing 1 option but when I combine it does not. =IF([Finding:…
-
Alert if a specific date is entered N times.
I am creating a "Covid Check-in' form for my office, where employees will use a form to check in with the date they are checking in. I would like to send an alert to the office manager if more than a set number of entries are made for any specific date. I.E. if more than 10 people check in on 09/01/20 then an alert can be…
-
Formula Question
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
Formula from Excel Help
Hello community, I cannot figure out why this formula is #UNPARSEABLE in Smartsheet when it works perfectly in Excel. The intent is to show the amount of days left before/after "Due Date" [Column5]. EXCEL =IF(E2="","",IF(E2<TODAY(),-DATEDIF(E2,TODAY(),"d"),DATEDIF(TODAY(),E2,"d"))) SMARTSHEET…
-
SUMIFS function
Dear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, where the following criterias are met: It must say "Ida Skou Andersen" in the column…
-
Struggling with SUMIFS
Dear Community, I am desperately trying to make a SUMIFS function work. I have to columns with dates, Start date (startdato) and end date (slutdato). I need to count the days in the period between start date and end date, and add them, where the following criterias are met: It must say "Ida Skou Andersen" in the column…
-
Selection of form in automated update request
I want to use differnt forms to request task updates, depending on my defined user group. E.g. an external user shall only see basic infomation and update a few fields, internal user shall see all information and update all fields. How can I restrict fields in a form, by user group? How can I select a specific form,…
-
Help w/formula that needs multiple AND functions
Hi team - I have a sheet w/over 100 columns and I'm trying to create a summary report that: Counts agreements created in July AND Is a "mandatory" column (check box) AND Is between the selected columns (actual range will be [Conflict of Interest Check of EMG & Board (M)]:[Conflict of Interest Check of EMG & Board (M)]) AND…
-
Nested If or Ifs
Hello, I have one cell with two pieces of data separated by a / but not all cells have two two data points. I have a formula to separate out the data to the left and right of the / when there are two pieces of data, but am struggling to find a way around the error of "Invalid Value" when there is only one piece of data in…
-
Calculating Year to Date Totals
I would like to automate the calculation of weekly totals from the previous year (2019) so that I can compare them to current year (2020). In order to do this I need to automate the calculation of the previous year's total by the current week number. The screen shot shows the totals by week from 2019 with the week number…
