-
Need help with buried IF statements.
I need help with a formula that I think will have multiple IF statements. Please see below. I am trying to determine the Maint Tech YTD Score. For the formula, we will only be using the "Community Average Score", "Company Wide Satisfaction Avg.", and the "Score Delta". We are comparing the Score Delta to the Company Wide…
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single cell. Is there a way to do this? Thanks in advance!
-
Reference an entire column and sync it with another column in a secodn sheet
Looking to take all 150 rows from a column in sheet 1 and sync them to sheet 2. Any changes to sheet 1 should be reflected in sheet 2.
-
Can I erase a reference name and reuse the reference name for another range?
Can I erase a reference name and reuse the reference name for another range? It looks like once I use a reference name and mark the range, I can't erase the name and reuse the reference name for another range? it will indicate the name already use on this sheet even I deleted this reference name? Is there a search function…
-
IF formula from multiple cell information
I've been tasked to show the approval status of a row. Due to how I created the automation, depending on the level of an award (same sheet as referred to recently) the Manager signer may show status in 1 of 3 different columns. I want to do the colored circles at the beginning of the row. Would do gray if the column is…
-
Is there a limit per sheet on the amount of cells that formulas are applied?
Hello, Is there a limit per sheet on the amount of cells that formulas are applied? I know there are other limits, like cell linking and the amount of rows on a sheet (5000). But as far as formulas?
-
DATEDIF for %Complete
Hi! I am wanting to write a formula to automate %Complete column. I have the start date / duration / end date. In excel I would write - =DATEDIF(A1, TODAY(), "D")/B2 - to find the difference between the start date and today's date and then divide by the duration. How do I do this in smartsheet? Thanks in advance!
-
How to add date to formula.
Hi so I am using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Not Started"). I want to also only filter by a certain date. how do I add that. There is another column called "due date" and there are dates in it. How do I only look at stuff due this month by adding it to the…
-
VLOOKUP + MATCH on column headers
Hi, I have a reference sheet set up with a list of milestone names/build versions/dates and am trying to use VLOOKUP + MATCH to auto-pull those in a 2nd sheet. For example - Sheet1 uses =VLOOKUP("ZBR", Milestones1:[2.0]7, MATCH("1.4", [Column Headers], false)) Where "Milestones1:[2.0]7" is a table of milestones/build…
-
IF Statement
Hello, I"m trying to setup a formula that if the reference cell = 0, then it prints zero (instead of @INVALID OPERATION) I can't seem to determine why I keep getting unparseable, not matter how I change it around. =IF ([Brand Funded Scanners]@row = 0, "0", [Brand Funded Scanners]@row * 259) Appreciate any assistance!