-
Report Date Sorting - Out of Order
Some of my report dates are sorting out of order, does anyone know why? Master Sheet 1: Dates in a column, both 2024 and 2025 data; Column Type = Date; All reports sort correctly Master Sheet 2: Dates in a column, populated by JOIN(COLLECT), cell formula; Column Type = Date; Master Sheet 2, Related Reports: Sort by "Store…
-
Locked out of account
We currently don't use SSO or manage Smartsheet accounts holistically in our enterprise. All users create accounts using their corporate emails themselves. A user who is no longer with the company has a Smartsheet account which we're trying to gain access to as they're the owner of a workspace. I’ve went through the…
-
How am I using this Formula wrong?
I get a "#INVALID COLUMN VALUE" error from this formula.
-
How can I reschedule all the tasks dates based on the last task done?
I Have a entire project but the date is fixed base on the lead time of the project. If i have a delay on a task, i need to see the move on the entire project in a new column, is that possible? In the image I have the columns "Planned start" and "Planned ending", the dates are fixed. Team is filling the colums "Real Start"…
-
Duplicated Columns
Hi guys, I'm trying to copy rows from 3 sheets to another, whenever I'm copying rows from the third sheet its duplicating one of the columns at the end even when all columns in all the sheets are in the same order. Any suggestion to fix this? Thanks in advance,
-
COUNT IF - CRITERIA
Hello Team, I have the following data to work on: 22-123 22-456 22-789 23-123 23-456 23-789 24-123 24-456 24-789 Where the first 22-, 23- and 24- represent 2022, 2023, 2024. I'm trying to use the "COUNTIF" formula to count them by using, the 22, 23 and 24 as criteria, to know how many items I have per year, however it…
-
Help Article updates: Bridge, DataMesh, and Calendar App Learning Tracks
Hello Community, We’ve created three new collections of articles that highlight specific capabilities: Bridge Learning Track DataMesh Learning Track Calendar App Learning Track To view the entire catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…
-
If & Workday Formula
What is wrong with my formula? I want to calculate 3 workdays from the survey request date but only if the site plan test fit is checked…
-
SUM Rows in Column A that meet multiple criteria including distinct values in Column B
I am trying to use a formula to: Referencing other sheet(s)… Sum story points by PE (Person) if: The Parent PCR (Identifier) is Unique The PCR Status is one of 5 options The PE assigned is an exact match (ie "Derrick Franklin") Here are a few that I feel are close, but not giving me the exact number's I'm looking for: This…
