-
How to rename multiple files in folders in a workspace com node.js?
Hi everyone, everything fine? I'm creating code consuming the smartsheet node.js SDK API. In this case I'm creating code to rename all the files that exist in folders in a workspace, not actually renaming completely just adding something in front of the name like the project name, but I couldn't do that, is there someone…
-
How to create a view/filter based off of a building column?
Is there a way to create a dynamic view/filter where all users assigned to a specific building can see all users within that same building?
-
Having Formula Troubles
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
-
Trouble referencing values in a "CONCATENATE" cell
Hello, I am having issues trying to reference the values in a CONCATENATE formula. I am trying to pull a "Yes" or "No" value based on the product numbers provided in the CONCATENATE cell. The CONCATENATE cell is the combination of product numbers added just for TODAY only (old lines do not show a value unless it is today).…
-
is saving Smartsheets has an issue?
-
Monster IF formula for date timeline
Link to the sheet: https://app.smartsheet.com/sheets/2VgXpPQp84VmwJhcMhmG5Mp993jXFqgfMJ9cqGw1 Trying to make a sheet that auto populates a timeline of dates based on two columns that have multiple options. The formula below in the Decal column works if one option is selected, but I need it to work if Bone@row changes from…
-
Help Article updates - July 2024
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…