-
Real-time Update for Sheet Summary
Hi, I have a sheet with months as columns. I have a formula to calculate monthly percent compliance when the numerator and denominator is entered into the sheet. For my sheet summary, I would like to see it update in real-time with the latest average percentage calculation, meaning it would show the average of percentage…
-
Duplicate Values For Columns with Hyperlinked Values
I've found a formula to indicate whether there's a duplicate value in a column, which is great. However, it appears Smartsheet does not recognize any cells that are hyperlinked so the formula treats this as a negative, even if the values are identical. I've noticed other issues related to hyperlinked cell values like when…
-
How can I set paragraph line spacing in Document Builder?
I have a series of documents that I have mapped in Document Builder. I need to have the end result with a set line spacing to match the rest of the text from the PDF. I cannot find this setting. I know that I could hard code in the line breaks in the formula, but my issue is that the values in the formula are of variable…
-
AVE or AVERAGEIF when refrencing another sheet
I have my master sheet set up with a duration column. I've been trying to build a formula on my metrics sheet that will allow me to average the duration column based on who is assigned that purchase order. I've tried two formulas, one using AVE and the other using AVERAGEIF and both return the #UNPARSABLE error. The first…
-
Stop counting NETDAYS formula based on date in another column
Here are the column names in my sheet that pertain to my question: [Address By Date] [Days Remaining / Overdue] [Date Resolved] The column formula is in the [Days Remaining / Overdue] column and I want it to stop counting when a date is entered into the [Date Resolved] column. The current column formula in the [Days…
-
Multiply Different Columns w/ IF(Or
I'm using the above formula to multiply "MSRP x Final Launch Qty" to find the Project Launch $. But I'd like to revise the formula to include" If 'Final launch qty' is blank, multiply MSRP x Brief Qty" Any advice on creating this formula?
-
Avoiding (email) notifications if assigned to = modified by
Hi all, I have set up a market research project plan with around 60 tasks. Each task is assigned to specific person(s) (could be multiple). I have a workflow where they 'assigned to' contact receives a (email) notification if the row on which he/she is 'assigned to' is changed. However, I only want them to receive (email)…
-
We are attempting to make a column from 1 sheet auto fill onto a second sheet and add new rows
We are making a database. We made a sheet for this (AllJobs3) and are attempting to have this sheet pull the Primary Column from a master sheet (All41). We only want the primary column as the database doesn't require all fields. We have been messing with INDEX(COLLECT), INDEX(MATCH), & VLOOKUP but we cannot seem to get it…
-
How to add multiple status criteria when counting tasks
I am looking to create two summary sheet fields. Formula 1. Count the number of tasks that are due within the next 14 days Constraints: Status must be "Not Started, In Progress, OR Scheduled Due Date must be within the next 14 days Formula 2. Count the number of tasks that are due within the next 14 days but also return…
-
How to Use IF with Multiple Criteria and then to plug in a date - Cross Sheet Reference
I am trying to write a formula that is referencing another sheet. If a row on 2023 Training Request matches the Location Tracker (where im inputting the formula - the studio code is the identifier) AND the Role dropdown on 2023 Training Request is "General Manager" then show the date in the Location Tracker that is in the…
