-
Can't see what I am doing wrong
Hello wonderful smartsheet users and apologies for a question that may not seem like it needs to be asked but I keep getting unparsable error for my cross sheet formula and i just can't see my error. I am trying to have Program name entered on my target sheet if the status on primary sheet says "approved"… this is the…
-
Help with # of days Formula. Returning "#UNPARSEABLE" Error
I am trying to calculate the number of days between two date columns in my Smartsheet: "Date" and "Date Closed". If "Date Closed" is blank (indicating the issue is still open), I want to calculate the number of days from "Date" to the current date. Here is the formula I am using: =IF(ISBLANK([Date Closed]@row), TODAY() -…
-
Using sheet reference to build placeholder text for an email alert
Hi I am attempting to build placeholder text for an email alert but I want to do it on another sheet referencing the data on my master sheet. It will include text and cell references. Basically I'm trying to write something like the following. "Hi name, Cardholder has made a purchase at Vendor for $XX.XX. Please review and…
-
#UNPARSEABLE when using Cross Reference
I am trying to "simply" use data from one sheet and if the cell is Yes, it then adds another Cross Reference to the new sheet. If (Cross Reference: Refile Access) is Yes, then (Cross Reference: User Name). If Cross Reference: Refile Access is no, then nothing would happen. Both cross references appears as being used so I…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…
-
COUNT IF Certain Project Category, resource and in Current Month
Hi! I am trying to create a sheet summary formula for each team member which shows the total files they have with a consultant in the current month. We generate a new sheet each month so i only need it to count after 1st of the month. I can't even get just a basic number of all projects with consultant after the 1st of the…
-
Stumped on an Unparseable formula
Hi all, I have a formula: =IF([New (Feb 2025) Account Coordinator]@row = "Carrisa Meeks", "GS 1 - WAREHOUSE") where if the column "New (Feb 2025) Account Coordinator shows Carrisa Meeks, then the cell should populate "GS 1 - WAREHOUSE". It works for all the other cells, exactly the same with a different column name and…
-
My risk formula for program row with child Projects progression is not working.
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress (% Complete > 0) but hasn't officially started yet (Start Date is in the future) - Indicates early progress or a potential…
-
Countifs not working properly
Hi Everyone, I'm looking to pull any trainings that were "Direct" from the Past 30 Days. Anytime I enter the formula it says #Unparseable. I'm not sure where I'm going wrong. =COUNTIFS({Training Type Column}, "Direct", {Date Entered Column}, ">=" & TODAY() - 30)
-
TIP: How to reference a \ backslash or " double quotes in formulas + [ ] in Col Names
While researching a problem I had and the absolutely simple solution that was causing it, I decided I would write this post to help people in the future. This is not an official post, just me trying to give back to the community in hopes it helps someone, so if you have more info to add (or correct me) please post it…