-
Cross sheet referencing, index collect for a range
I have a source sheet of different items, rolling out on different dates for different stores. I am creating a target sheet of a rollout of one specific item. I want the target sheet to list all the stores on the source sheet, that meet the criteria. The formula below, works but for one row (one store).β¦
-
I need a modification on an IF THEN statmenet
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),β¦
-
How to auto-populate a form using data in reference sheets?
Is there a way for Smartsheet to auto-populate a form with reference information from a 'master sheet' as I'm filling it out? Example: I'm trying to build a survey within Smartsheet and want to have a master sheet that contains all of the non-profits that we participate in. Upon selecting a non-profit from a dropdown inβ¦
-
how to change Parent status based on Child row checkbox?
= "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm hoping to find a way to do it automatically with a formula. I've only had success with formulas changing status within theβ¦
-
Monthly Allocation Variance Formula Help!
Hi, I am struggling with my formula to calculate my monthly percentages and show the variance across each month as the projects approaches the end. For instance, we have a project that may have started 10/1/2024 and is going to 10/12026, It shows 0% not acknowledging the months or years in between. Or if the project startsβ¦
-
Cross Sheet Formula
Trying to do an if and statement. If the PO# matches on sheet one with PO# on sheet 2 and the Count of POs (a count helper column restars at 1 with each new PO) equals 1 then post the Inv amount. =IF(AND({FY25 Payables Tracker PO#} = [PO #]@row, {FY25 Payables Tracker Count POs} = 1),{FY25 Payables Tracker Invoice Totalsβ¦
-
Multiplying Cells When One Is Blank
Hello, I'm hoping someone can help me figure this out. I want to multiply the first three columns, with the total showing in Total Number of Delivered Training Hours. However, that field keeps showing as 0 if one of the cells are blank. I tried using this formula, but it still just returns as zero: =IF(OR([Total Number ofβ¦
-
Help converting Excel formula to Smartsheet
I imported an Excel file into Smartsheet, and am stuck trying to convert this Excel formula into a functioning Smartsheet one. I know some of these functions are not available in Smartsheet. However, I've tried a lot of different formulas and am still having trouble. I've even tried using ChatGPT and it's proven to beβ¦
-
Left Function
In the Left function, is there a way to grab just the letters, not another character, such as a dash? I have a column of numbers that include 2-3 letters, a dash, a number, dash, then 1-3 letters. Example: XX-10000-WQA, XXX-10000-WQA. I would like to have a column that just shows the first 2-3 letters, without the dash, ifβ¦
-
Hyperlinks - Copying a Folder set where links stay with new sheets
Please tell me there is a solution for this.. I have a set of sheets, reports and dashboards. In one of the sheets there is a project plan and I've created hyperlinks to the relevant reports/dashboards within that folder. When I copy the folder, the hyperlinks refer to original sheets/reports and not the new ones. I'veβ¦