-
How to: From a specific number to allocate a contact?
We have assigned numbers for each department. And I want to make a formula or automation that if there are some specific numbers they will be assigned to a specific team member/contact - as to remove the need to do this manually or to ask them to do this. New to Smartsheet. Thank you
-
Column formula for only Children rows with Parent row =SUM(CHILDREN())
I have PARENT and CHILDREN rows with the column where for PARENT row I indicate "TOTAL" in separate column. I would like to create Column Formula to calculate "Estimated Total" either for PARENT raw or for CHILDREN row automatically.
-
Formula works unless there is no date and then it returns the dreaded #Invalid data type.
=IF(Helper@row = "1", "January", IF(Helper@row = "2", "February", IF(Helper@row = "3", "March", IF(Helper@row = "4", "April", IF(Helper@row = "5", "May", IF(Helper@row = "6", "June", IF(Helper@row = "7", "July", IF(Helper@row = "8", "August", IF(Helper@row = "9", "September", IF(Helper@row = "10", "October", IF(Helper@row…
-
Get the column or collection index of a Matched value
In the example below I am trying to get the array index of the matched value. I'm looking for the number in columns Jan - Dec where it equals the value in Current Month. I can find the value, but I need the position so I can derive the financial period the entry falls into. Or better yet, how would I get the position of…
-
How do we apply COUNTIFs with multiple conditions?
I Have 5 Columns namely Phase 1, Phase 2, Phase 3, Phase 4, Phase 5 I need a count of each row item (Less than 100%) with a condition that if a task is less than 100% in multiple columns like phase 3 and phase 4, it should be only counted in the first column (Phase 3 in this example)
-
Return the highest and 2nd highest value
Hello, I need a formula which will return the highest and 2nd highest value. For the table below, it would need to return "Wednesday" as the highest and "Tuesday" as #2.
-
Report Summaries - RAG Status Summary - Functionality Request
A major limitation I am currently finding with Smartsheet is the ability to be able to pull RAG status summaries into Report Summaries for charts and consolidated reporting across multiple projects. For example - 10 project plans with 5 business units where I need to track % complete and RAG Status (which is based on…
-
Master File sending selected columns to new consolidated sheet
Hello all, I'm quite new to smartsheet and I'm trying to find advice on consolidating data. I have a sales report that comes out of my ERP that has info on orders for multiple customers, sales data, delivery dates and plus loads of extra data. I wanted to upload this master file once a week to smartsheet and then have…
-
How to show if any child task has status 'in progress', parent row also 'in progress'?
I want it so that if any child task is 'in progress', the parent row shows as 'in progress'. (Shot 1) I can get the first part of this set up in an individual task by using =IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress". (Shot 2) BUT then when I try to apply it to the entire column/sheet, gets rid of the other…
-
Using Collect with the large function
I have 3 columns in the same sheet: The formula that is in the Case Total/Supervisor is (this works perfectly): =LARGE([Total Issues]61:[Total Issues]150, 1) I am trying to do the following: I want to collect the name in the row with the Largest value. These are higher up on the sheet. Put that name into the Name column.…