-
Text in cell to translate to Number if different cell
I am trying to write a formula that when Client Name says Weekend Stay to populate $150 in the Rate of Pay column.
-
AND and HAS functions in a formula
Looking for help to put the below formula into the right order. I have played around with where I put the IF(AND and HAS functions, but stays unparseable. I need it to sum the award total if the grantor is at primary column row for the FY at row if the Status is Awarded and the Funding Source is Federal. =SUMIFS({Award…
-
I am getting the following error #NO MATCH
I am getting the following error #NO MATCH when I try to connect the Project ID from the Project Intake Sheet to the Project Metadata sheet.
-
AI formula generator is not working
Dear Community, Kindly help to find the right way to resolve my issue. For about a month I am trying to get help from Smartsheet support as AI formula generator is not working with my account (Enterprise license), no matter what wording am I using. At the same time, at my coworkers accounts all works well. Smartsheet…
-
How to sum cells from different sheets?
I have six sheets with numbers in each cell. I want to make a 'TOTAL' sheet that sums up each corresponding cell in each of the six sheets. For example, sum the A1 cell in Sheet 1, 2, 3, 4, 5, 6. And then sum the A2 cell in Sheet 1, 2, 3, 4, 5, 6. Basically the A1 cell in the TOTAL sheet should be the sum of Sheet 1, 2, 3,…
-
Vlookup/Indexmatch (retrieving date from one smartbook to generate in main sheet)
Good afternoon I have figured out the vLookup formula in Excel but I am having issues in Smartsheet. I want to enter a name in my main sheet (2025 OT Tracking) and then I want the Cost Center to auto-populate from my second sheet (CC&Names). I have looked at numerous formulas and I am still struggling.…
-
Sum Multiple Criteria
I'm looking to sum the total in the CS Error Cost column anytime the Responsibility column equals CSC, ISG or UAL. I've attempted different nesting versions of the SUMIF and SUMIFS but keep getting an error. Below is one example of what I attempted. =SUMIF([CS Error Cost]:[CS Error Cost], Responsibility:Responsibility,…
-
Multiple Condition Duplicate Line
Hello, I am creating a tracking system for PO's that need to be entered into a system. The problem is that a PO can be split into multiple truckloads and delivered to the facility on mutliple dates. The facility enters each PO that is needed based on a schedule but if the PO had been received previously, they do not want…
-
Challenge with counting different columns in a sheet when a reference to another sheet exists in a d
I have entered the formula below to count the number of times a box is checked in a particular month in another sheet. When I try to apply the same formula to another column in the sheet below (writing manually or copy/paste) and select a different column in the other reference sheet to pull the checked box count from it…
-
Update Request Not Working as Planned
Hi there, I have an automation for my team's project sheet that sends an update request for every item that has a status other than 100% or "Not Supported." But it's sending update request for projects that are at 100%, which is both confusing and annoying for my teammates. Below are a couple of screenshots. Does anyone…