-
How do I create a hyper care Line Graph for a dashboard
I need to create a specific line graph for a dashboard. This is what was requested but I am unsure how I need to structure my metrics sheet? X-axis = Dates, Y-axis = Number of stores. One line graph (in the case below, the Squared Milestones) would show the number of stores we planned to upgrade every day, and the other…
-
If Formula & Symbol
Good day, In our Company we use "Stages" to determine the quality/lead time of a new sale. We have 6 Stages. Stage one which is a potential client that has low intrest (cold Lead) and where stage 5 is a hot, almost sold client. Stage six is when the client bought one of our equipement and the order is successful. This is…
-
need a formula to retrieve a value from an array
hi everyone we receive an array from external source to our sheet with questions and answers (the id of the question never change on each line) this is the content of the cell value that I receive from external source : [{"Answer":"fix","AnswerOptions":["fix","mobile"],"Question":"Do you have a…
-
How do you calculate an average on a column that also contains "#Invalid Data Type" in some cells??
I have a column of numbers (days duration) between two date columns but, in many cases, one of the dates may be missing which gives me an #Invalid Data Type entry in the column where I am averaging the days duration. Attempting to average the column, I don't know the syntax to skip over the #Invalid Data Type cells to only…
-
If filled date in row show procent in next row
Hello, Please help with the function in the sheet, How to make a function when a row is filled with the date that the automatically next row will show the percent. An example is from the Excel file of how this should look, a screenshot is attached to the post.
-
Index/Collect returning #INCORRECT ARGUMENT SET
Hello, Community! I'm trying to bring in the value of the Available? column from the Availability sheet into the same named column on the Schedule sheet where: (1) Rescheduled on Schedule sheet matches Team Member on Availability sheet and (2) Start on Schedule sheet matches Date on Availability Sheet. My current syntax…
-
Need a formula to return a first word
If column has values NET or NET12 or NET,WEB or NET12,WEB or NET34,WEB12 value needs to be return as NET also, if values has Test or Test12 or Test Test, Prod or Test12, Prod or Test 34,Prod56 value needs to be returned as Test. If it is Dev_Unit_test, same value needs to be returned as Dev_Unit_test.
-
Fiscal Week / Month / Year
Greetings All! I am stumped trying to get a Grid to formulate for Fiscal Dates. I am trying to report out and showcase on a Dashboard what has been done This Week (Sun - Sat) , Last Week, This Month, and This Quarter. I have tried several IF, DATE, and various other formulas. I have the report aspect fine, as well as the…
-
How to prevent Smartsheet from Rounding Dates
Hello, I'm having trouble with Smartsheet rounding Sundays to Mondays and need help with my formula below. I'm using the Created Date column to capture when a submission is filed into our Sheet and another to capture Weeknumber. However, Smartsheet keeps rounding the Sunday entries to Monday if they occur after a certain…
-
When a date is chosen that is after 12/31/2023 move to another sheet
I have a date field and want to set up an automation that if they choose anything greater than 12/31/2023 it moves that row to another sheet. Thanks,