-
Get Date and Time from a column
I have a spreadsheet, which contains a Check Box type column, when it is selected I needed to save the date and time in another column for SLA, I've tried different ways and none of them work, I thought about copying the line and getting it the modified column, but the problem is that it keeps updating, does anyone know…
-
Checkbox is Missing
Help! I have been using smartsheets for 6 years now and have always had a checkbox in two columns. Somehow when I opened my sheet today they are missing for any spots that it has not been checked yet. The boxes dont seem to be hidden as I don't seem to be able to hover over the space and check it off. I have checked the…
-
June 2024 Help Article updates
Hello Community, We’ve created new content to highlight specific capabilities: Data Shuttle Integrations landing page AI Tools Learning Track We’ve updated the following articles: Configure Azure for domain-level SAML single sign-on to Smartsheet Control Center Global Updates: Update reporting Send automated email…
-
Using Reference Sheet to toggle Checkbox
Hello, I've been digging and digging through Smartsheet posts and other references and cannot seem to find a comparable reference to use for my use case. I have 2 sheets. The first sheet stores PMs for equipment inspections. There is a column for "Equipment Name" and a column "PM Date". The second sheet has a column for…
-
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"…