-
Wildcard workaround
Hi, Trying to get some counts for a report and have run into a bit of a road block. In excel, I would typical use a count formula and a wildcard. However, Smartsheet doesnt seem to have the capability. Below if my code: =COUNTIFS({Papers Range 2}, "*O'Malley*", {Papers Range 3}, "1 - Published") How would I edit this to…
-
calculate maximum date
Hi everyone, I need your help to calculate the maximun data for each resource, starting from a sheet where the activities are recorded. I have a sheet where I write all tasks for each resource: I need to have the maximum date present in the "task" sheet for each resource present in the "resources" sheet Can you please help…
-
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…
