-
Formula Issue
I am trying to write a formula to return the following: If Column A is not this, and Column B is this, return the result in Column B in Column C. Does anyone have advice? I think it should be fairly simply but I keep getting the unparsable message. Thank you in advance!
-
Formula errors: "flashing" #BLOCK errors and formula referencing wrong rows
Hi All, I have some sheets that have some heavy formulas and there are two issues: Whenever I update a cell (without formula) the entire sheet just start "flashing" with #BLOCK errors in pretty much all cells with formula and then these errors disappear after 5-10 seconds or so, but that's with every single update. I think…
-
Can SmartSheet Count & Return all other values besides "X"
Hello Everyone, I have a metrics sheet that is counting specific text ("Alpha") from a source sheet with the following formula: =COUNTIFS({Supplier}, Description@row, {Status}, "On Order") **This works** Ideally, I would like to count all the non-blank cells that do not have "Alpha" inputted. Can this be accomplished?…
-
OR(HAS Function - limits to criteria?
I just learned from a ProDesk session that we needed to use HAS rather than CONTAINS, since will have more than one entry in a cell. However, we have one set of counts for three criteria in a cell. When I added the third one to the formula, it returned Unparsable. Is there a cap on how many HAS criteria you can count?…
-
Calculating work completed and forecasts
I want the smartsheet to automatically update the “WIP (local)” column each month and reduce the current months forecast to £0. As you can see below, the “WIP (local)” column has increased and the forecast for September is £0 (this is fine). However, the smartsheet has now overestimated the total cost of the task (work…
-
If/Then formula with two options based on a date?
Hi all, While I am getting the hang of Smartsheet, I'm still a novice with formula. I currently have a column formula =[Record Entry Date]@row + 8 This adds 8 days to the "Record Entry Date" to create an "Archive Date" for each row. However, I now need to adjust the formula to be either 8 days or 30 days, depending on the…
-
Project Schedule Health from PMO Template
I've search the community and I think I'm just getting myself more confused since I'm not good with writing formula's. I downloaded the "project plan" template and I am still confused. I would like to show the following (I hope I'm explaining this right 😩): Blue (complete) = if schedule delta is = 0% AND % complete is 100%…
-
Counting and Dividing Certain Cells
I want to divide the number of requests that were completed on time by the total amount of requests submitted that month. I'm referencing another sheet in my formula. The following is giving me "UNPARSEABLE" =IF({On Time?} = "Yes", {Submitted Date}, YEAR(@cell) = 2023, {Submitted Date}, MONTH(@cell) = 1) / ({Submitted…
-
INDEX/MATCH returning #NO MATCH error but only for ONE cell
I have the following formula checking for matching emails in two sheets & returning the date: =IF(Done@row = 1, INDEX({Submission Date}, MATCH([Email Address]@row, {Submission Email})), "") It's inside an IF statement because the Done column checks if there's a submission for the email in the first place--I only want the…
-
Index Collect that excludes previous values in returning sheet
Hello- I am attempting to create an architecture where employees are auto-populated based on role. I have a sheet with the entire orgs employee list that contains names, employee numbers, and titles The working sheet is attempting to pull in all people of each job title. Each row is a job title (same title with multiple…
