-
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…
-
Point Tracker System
Hello, I am wanting to build a system for tracking points. There are two kinds of points: good and bad. Simply put, I want to keep an up to date tracking for each employee. Here is what my starting base is: Now here is where I am getting stuck. How do I make it so that I can reference a specific employee's total from a…
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
No Drop Down entry for the week
I am looking for a formula to indicate if there are no entries of an item in a drop down menu within a particular week of the year. Below is a brief rundown of what I have accomplished, and what I desire. I am looking to create a report or dashboard to reflect if an inspection on a particular device has been completed for…
-
Reset Value to 0, No negative numbers
Is it possible to have a number go down the 0, but not have it have a negative value? I'll share my sheets to illustrate. So this is my current sheet. I am running into an issue where people are having a negative total (picking up a ton of OT shifts) and they accumulate a big negative total value, so when they do no-calls,…