-
Incorporating ISDATE into Formula to average the time between various dates if conditions are met
I have a formula for calculation of a row by row average of review cycles, where each row can have 3 review cycles. I'm trying to figure out how to incorporate the "ISDATE" Function into this formula such that if one of the review cycles is unnecessary and a user enters "N/A" the formula will still calculate correctly.…
-
Trying to JOIN/COLLECT across several multi-select columns in a different sheet
I've spent a fair bit of time trying to figure this out with no luck. I suspect at least part of it can't be done with multi-select columns but I'm sure some of you good people can school me on this. I'm trying to join the values of 6 multi-select columns on one sheet into a single column on a separate sheet. Cells can be…
-
complicated formula
Hello, can you please help me solve this formula. I don't understand what is wrong with it.
-
Need Help with INDEX(COLLECT w/ CONTAINS
Hi All, I'm trying to populate a column with a global Region value (AMER, APJ, EMEA) based on a local region code contained in an appliance name. I have two sheets with data. Sheet 1 contains a column of appliance names and a second column for the Region I want it to populate. Sheet 2 has two columns, 1 for the Data Center…
-
Index/Collect with Specific Criteria
I am trying to automatically populate the Parent "Content Development Status" column based on the most recent "Child" in the "Tasks" column, but there are certain Children rows in the Task column that I want to ignore. For example, if there is a webinar delivered, I do not want this to populate in the Content Development…
-
How to calculate duration based on workdays, and deduct 0.5 days
Hello, I would like to track planned leave and duration for my team. On my sheet, I have "Start Date", "Half Day Start", "End Date"; and "Half Day End" columns. If Start Date is Mon 24-Jun-2024 and Half Day Start is Ticked; and End Date is Wed 26-Jun-2024 and Half Day End is Ticked, the Duration should be 2 days I am using…
-
Need a formula to fill in a column based on a date column
Hi! I have a date column and i would like a forumla in another column to complete that cell with the word "completed" when the date is added. Im creating an exterior report that i want to show just the info for the completed rows but the only way we know its completed is by this date being added. If the date column is…
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
-
Formula help
Hello, I used the below formula to return the total dollar amount to the main budget actuals sheet if the two Spend Category columns matched on the two different sheets. The issue is it only returns one of the dollar amounts instead of totaling all the money under the same spend code. How do I fix this formula to add the…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
