-
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!
-
Index Match Issue
Hello, I seem to be having an Index Match formula issue that I cannot figure out. I've used this formula many times and never had an issue. The screenshots attached should explain fully what is going on. For some reason, it seems to be returning the same (wrong) value in multiple cases in the formula. Thanks for any help…
-
Health formula from Status
Hi all. I'm new and trying to tweak a health column formula. We've decided to remove our % Complete column which we'd originally used. Original Formula: =IF(AND([Due Date]@row < TODAY(), NOT(ISBLANK([Due Date]@row)), OR([% Complete]@row <> 1, ISBLANK([% Complete]@row))), "Red", IF(AND(NOT(ISBLANK([Due Date]@row)), OR([%…