-
Is there a way to conditionally copy the value of one cell to another?
I am trying to create a modified auto-numbering scheme where the numbering is based on a parent/child relationship. I think I am on the right track, but have hit a roadblock. My end result should be a calculated ID that is not overwritten when IDCalc changes. I would like the value of IDCalc to populate in the ID column…
-
How to automatically check a parent row when children are checked?
Hi, I have 3 level parent-children rows. I also have a column with a checkbox. Is there a formula or automation that would check the parent row if all children are checked?
-
Join-Distinct-Collect Formula Returning #INVALID DATA TYPE
I'm using a Join Distinct Collect formula to return a list of product numbers from a detailed schedule (formula below). I use this and other formulas to populate a weekly summary sheet. =JOIN(DISTINCT(COLLECT({Schedule Item}, {Schedule Make Date}, =Date@row, {Schedule Room Name}, =RmName@row)), ", ") Whenever the schedule…
-
HAS cross-sheet reference & Invalid Column error
I am trying to use HAS in a cross-sheet reference. I have a drop down form where the user selects a Strategic Priority and it goes into Sheet A below. In Sheet B, I need a formula to pull the text of the most recent selection. Here is the formula I am using in Sheet B, where Range 1 is the "Latest" column and Range 2 is…
-
Cross-Sheet formulas with Max Date
I'm a new user and trying to use a web content form widget to filter a report on a dashboard. I've got the form built and the form widget working on the dashboard. The form selections go to this Sheet A, where I have it set up that the box will be checked for the most recent selection. The report that I want to be filtered…
-
Formula to return a value if date is between entered date and calculated date
I have 2 sheets. On the first sheet I have a start date (entered value). From the start date I calculate the start date of the quarter of the entered date, and I also calculate the end date of the quarter 1 year later. All three were created as Date fields. As an example, if the date entered in 11/16/2023, the quarter…
-
Possible to automate numbers per row type?
I am adding a PO system in our smartsheet that holds different types of financial tracking. I want to auto populate new PO numbers, however, only for a row if a different column is marked as "PO Request." Is this possible? Currently the autonumbering feature does all rows. I've tried the following column formula so that if…
-
Why is my formula unparseable?
=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A") The bold is what I want to subtract within the formula.
-
How to put contact list names into a visual graphic from a multiple contact column
Hello! I have a tracker for my project team that shows all active projects and their details. One of the columns is called "Project Team" where the PM is asked to list out all individuals who are on their project team. The column lets them add as many team members as they need to. I have been asked by my Director to turn…
-
Bi-Weekly date formula.
Thank you in advance for any help on this! So, I am using this formula: "=TODAY() + (6 - WEEKDAY(TODAY()))" to show a weekly task that is always do by Friday every week. I like this one because each Sunday it updates to the current week automatically, making so that this task it is attached to shows up on the calendar for…
