-
How to return most recent value when conditions met. Smartsheet Support is Stumped
Hello, I stumped Smartsheet Support with this formula question: I want to return the most recent approval status from another column based on common Project ID. I have four columns: Created Date - Project ID - Enter Status - Project Approval Status (Where the formula exists) All the columns are text except for Created…
-
Dashboard label values overlapping
I wanted to show sales figures in the dashboard, but values overlapping with other data. Can anyone help me to solve this problem?
-
Array formulas for project completion in Smartsheet
Hello, I have a project plan in Smartsheet with 2 columns: % Complete Relative weight of completion This cells are used in parent rows (the phases of the project) and are used to indicate the completion of a phase but also the relative amount of effort that each phase has (as an average is not accurate enough) I would like…
-
How would I split text separated by commas into new cells?
Example, in one cell I have the text "Zach, Max, Prince, Bob, Rick and more" How do I split that to have each name in each column, all on the same row?
-
How to check if children cells are blank?
When the following formula is applied =IF(COUNTIF(CHILDREN(), OR(@cell = "Yes", @cell = "N/A")) = COUNT(CHILDREN()), "Yes", "No") it results false positive values since blank children cells are counted. There is ISBLANK() function. How to use it to apply the above formula only if all children cells are not blank?
-
Convert this formula to a column formula
This formula is working at the cell level but I would like to convert it to a Column formula so it automatically applies to new entries added to the sheet from a form. =Weight2 - $Weight$1
-
SumIF between Sheets
Hi there, I've reviewed past chats about this issue, but can't seem to resolve it on my own. NOTE this is to run SUM IF between two sheets. Before I get into the details: Can someone please confirm that SUMIF won't sum a range based on a formula used to calculate that column data? i.e I used an IF formula to get the…
-
Change a form submission + approval needed
Hi all, I'm working on a build request is asking: use form to submit new project - DONE be able to revisit the prior form submission to change certain key fields the key change needs to be approved before data change is made on the sheet Can someone provide some ideas for step #2 ? some posts mentioned about Dynamic…
-
Smartsheet CountIFs
I have 2 SmartSheets. The first one (Sheet1) has customer data with some transactional information ('Customer Number', 'Order Number', 'Order Number', 'Licenses Used', etc.). The second one (Sheet2) has all transactional information ('Customer Number', 'Part Number', "Serial Number', 'Entitlement Complete (Y/N)', etc.).…
-
Does editing drop down list cause issues with past data?
My team currently uses Smartsheets to track our customer engagement data. In a few of our columns we use drop down choices with lists of team members, technologies, ect. If I delete a name or technology from that drop down list will is interfere with viewing historical data? ie: If I delete the name "checkers" from the…