-
Vlookup issue : When column are added to
Hi, I have successfully applied a Vlookup from reference sheet to my parent sheet. However, when a new column is added within that range in reference sheet then input value also changes and it doesn't remain static. Is there a way to apply same logic like Excel with $ sign to make the Reference value/Reference column…
-
Help with this IF this then this formula
Please help me figure out what I am doing wrong with this formula: =IF((([Size of Install]@row = "Small - Single Server, no HA, no NLB, HPAC PP+IA+, no HPAC Scan, no HPAC mobile connector, includes PPM/PDM, WJA, UPD, 500 printers or more - remote/travel extra, for small AlertX configuration only, single server for PP,…
-
Multiple Results Formula
Hello! everyone I was wondering if someone could help me with a formula We have an audit schedule based on 5 years and I currently have the "Count" essentially telling me how many times a topic was audited in the past 5 years. What I would like to generate is - "in which years was the exact same topic audited?" which would…
-
Using "If" with dates
Hi all, I'm working on a sheet where I'd like to reference a start date for a task and then, based on the current date, auto-populate another column with a status update (not started, in progress, overdue, etc.). I think I want an "IF" statement-something like "=IF([reference column])>today, "Not Started") but I"m 100%…
-
COUNTIFS - Multiple Columns if blank by person
I am looking to count by the person if they have not entered data in the cells within a column. If person A is missing six (6) cells within three (3) different columns then the calculation should only calculate that person one (1) time. I have created helper columns to calculate how many people have missed entering data.…
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
IF Formula with Children
Hello Everyone, I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case Status" column should be "Completed", otherwise, "Pending" Thank you in advance.
-
COUNTIFS with OR and ISBLANK to find number of blank cells 7 days ago
Hi, I have a formula that is working to count the number of active employees in Role 1, Role 2, Role 3, and Role 4 who did not qualify because the date field is blank. =COUNTIFS({ROLLUP-EmpStatus}, "Active", {ROLLUP-Role}, OR(@cell = "Role 1", @cell = "Role 2", @cell = "Role 3", @cell = "Role 4"), {ROLLUP-QualifyDate},…
-
Year( formula issue
Can any one help me why this formula doesn't work. It results in #invalid operation =IF(YEAR([Project Works Commence]@row = 2022), WEEKNUMBER([Project Works Commence]@row), " ")
-
Is there a way to add data to one sheet and have it automatically pull to another sheet?
I have two sheets, and they share a similar column, but only that one column is consistent between the 2 sheets. The column is called "record ID#". I am hoping there is a way that once I add a new record ID # to one sheet (Sheet #1), that record ID # can automatically populate on my other sheet (Sheet #2). Just the record…