-
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/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
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…
-
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,…
-
Can I use Vlookup to check a date range!
Hi All, I have a multiple scrum board sheets. In these sheets I have a closed date column. I also have a field with the Sprint # an Quarter. This sprint number field is not relevant to the task owners, it is more to internally map the tasks and do some statisctics. I have another sheet (my refernce sheet) which gives a…
-
Adding "$" sign to an ABS formula
I'm doing a round-up formula for budgets and the formula works $8,378,398 shows round to 8.38M - formula is =IF(ABS(Budget55) >= 10 ^ 9, ROUND(ABS(Budget55) / 10 ^ 9, 2) + "B", IF(ABS(Budget55) >= 10 ^ 6, ROUND(ABS(Budget55) / 10 ^ 6, 2) + "M", IF(ABS(Budget55) >= 10 ^ 3, ROUND(ABS(Budget55) / 10 ^ 3, 2) + "K",…
-
Countifs
Hi, I am trying to count the number of entries in multiple columns between dates in another column in a metrics sheet. Here is what i am trying however i am getting a error. =COUNTIFS(Design Services Projec Range 12}, {Design Services Project Range 4}, >=DATE(2020, 1, 1), {Design Services Project Range 4}, <=DATE(2020, 1,…
-
Counting Distinct with multiple ranges
Hi All, Thanks!