-
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,
-
Count Year and Month Only from Separate Smartsheet
Hi all! New smartsheet user and learning formulas! I'm trying to count the number of jobs in a month per project type from a separate smartsheet (to eventually be turned into a graph). The date format in the original smartsheet or month/day/year. I just want to count the month + year. The Project Type is also in a separate…
-
Auto Fill Formula
I am trying to auto fill a field named "File Name" based on the content in other columns on the same sheet. The tricky part is I need the "File Name" to end in ".jpg" or ".pdf based on what is selected in the 2nd column. Below is an example of the data and manually filled in the data for my File Name column but that is…
