-
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…
-
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…
-
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…
-
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…
-
Date and Balance Formula
Hi there, I need help creating 2 formulas I am trying to create a formula that takes into account if the Week Ending is a specific date than the balance for that week ending displays accurately. The second formula would essentially be the same if the Week Ending is a specific date what are the number of hours being…
-
How to combine if/or statements
Hi, I am trying to create a formula so that if days open is >=4 color turns red, if days open is >=2 color turns yellow or color is otherwise green OR if the resolved column is check the color is green I am trying to combine the below two formulas but can not seem to get it right. =IF([Days Open]@row >= 4, "Red", IF([Days…
-
Display a calculated, non-editable value on a form based on form values
Is there capability to display a calculated, non-editable value in a form? The previous fields are inputs to a conditional formula and I would like to display the results within the form if possible but I can't seem to find a way to do that. Thanks, in advance! Mark
-
Expressions in Data Uploader
I have a Workflow template and a few expressions someone created before me. My goal is to have a sheet that is manually populated and then we drop in a .csv file every so often and it updates the Status field and the Account Balance field. Pretty much everything works except for the Status field needs to be updated…