-
MAX COLLECT Formula
I have one table for shipping (Production Priorities) : And another table for Project Revenue Recognition (Revenue Recognition Forecast): I would like to write a formula to auto-populate the max ship date for each project. =MAX(COLLECT({Production Priorities Range 1}:{Production Priorities Range 1}, {Production Priorities…
-
Remove a Decimal in Column without Rounding
I have a column set up for a Retail Price, currently it looks like this: 3.99 I need to pull this column into another column with a column formula, but I need it to be formatted without the decimal, without rounding. So in the column formula I want it to pull in and look like this: 399. The column formula is automatically…
-
How do I copy a formula and update a cell reference
I'm an excel user, but new to Smartsheet so I'm still trying to figure out how it works. Please see screenshot attached for reference - I have a formula in the "Yes_2" cell (circled in red). That formula references another sheet "CSF Questionnaire Range 7" (highlighted yellow). Next, I copied the formula and pasted it in…
-
Supply a count of a select status based on a date range, then supply a sum...
Good Morning SmartSheet Helper Gurus.... I have the need to get the number of Status = Closed for a select date range, then tell me the Sum of the Story Points column for those closed tickets. I can get my number of closed ticket with : =COUNTIFS({Story Point Reference}, FIND([Primary Column]2, @cell) > 0) I can get my…
-
Automation workflow - Alert Someone (include multiple email address in same thread)
Hello Experts, I have an automation workflow set with my document to Alert Someone when changes are made. The workflow is triggering email without any issues, however, it is generating separate email to each individual. In that way, if one wants to Reply All to the email chain, no other contributors are included in that…
-
why is one of my teammates showing as publish user
I have added my teammates to my worksheet with edit-share capabilities but out of the 9, only one keeps showing up as publish user and when he makes changes to the sheet, the automated emails say my name. Everyone else, their name shows up. what could this be?
-
Can you combine an If(ISBLANK with OR
The formulas below work independently. I would like them to work together with an OR function to Check a box. Every combination I try is not working. =IF(ISBLANK(Role@row), 0, 1) =IF(Level@row <> 2, 0, 1) Any assistance you can offer is appreciated. Thank you!
-
Primary Column Revision
Good evening We madea mistake when building our sheet. In the primary column we need to be able to have the "Child" rows equal what the "Parent Row" days plus the verbiage currently in the "Child" row. So we would like the "child" rows to say 140 Kendrick - Egress Stair - Approval Drawing.....etc etc . How do we do this…
-
Changing WEEKNUM formula to pull on Sunday's instead of Monday's?
Hello, I have a sheet that acts as a "day tracker." Each row is a new date that tracks specific data in each column. I have a "Week Number" column attached to the "date" column, however the week number populated does not match the week number shown in Outlook calendar and Excel. I think this is because Smartsheets starts…
-
Adding Months based on Calendar Days not individual days
I am looking for a formula that adds months to a date and keeps the "x" day of the month. Meaning if I am adding 3 months from February 1st, 2021, it would return May 1st, 2021 vs. just adding 90 days to February 1st and returning May 2nd, 2021.