-
Help Article updates
Hello Community, We’ve created new content to highlight specific capabilities: DataMesh Learning Track We’ve also created or updated articles in the following areas. Get help AI tool: Find relevant answers with the get help AI tool Time-based one-time passcode (TOTP): Email-based TOTP overview (for System Admins)…
-
Help with "Simple Project Portfolio" template
I really want to use the Simple Project Portfolio template but I can't seem to get everything in the "Save as New" folder to do so while keeping all its connections. Maybe I have missed a "how to use" section with this template or just not seeing something obvious any help is greatly appreciated. NOT REQUIRED: I learn best…
-
Smartsheet Control Center - Delete Predecessors
Hi all! I have a question about control center. I want to make a global update but it's not possible in a predecessors column. Context: ~1200 projects already provisioned ~500 have data related to the predecessors we don't want to lose So I THINK I can remove the predecessors from the blueprint sheet itself and then…
-
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…
-
Problem saving smartsheet spreadsheet
When I try to save any changes to the spreadsheet, it loads for a long time and then gives me the error: formName: ajax formAction: fa_gridSave serverStatus: false serverStatusText: CriticalException errorCode: 48
-
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…
