-
Help with INDEX/COLLECT with a MAX/COLLECT
I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would like to use the row with the MAX Fully Executed Date. Below is the formula I am using: =INDEX(COLLECT({IA Assigned}, {RTO…
-
Data Shuttle Upload - Merge & Update based on key column value causing errors
Hello! I have a few Data Shuttle automations running between SharePoint / Power Automate created .xlsx files and a central repository in Smartsheet. Our key identifying point is a unique profile ID number, but we do need to use that ID number for our contractees when requesting a contract renewal. Due to this, during the…
-
Mass transfer
Hi We had a mass transfer of documents done to the wrong person. After looking online I see that there is no way to redo it. We are trying to do it it individually however we are running into the problem that the sheet owner is not the Workspace Owner and the Workspace Owner is OOO. The person who over sees Smartsheet said…
-
automated Archive
Would love to be able to mark a sheet as "complete" in the sheet summary and then the sheet automatically gets moved to an archive folder or a completed folder.
-
Where you do you associate the correct Google account with Google Calendar sync?
For some reason, the calendar is sending to a Google account that it not the same as the address associated with my Smartsheet login. How do I change that?
-
DataMesh is defaulting to Column mapping instead or Row mapping
Totally perplexed. I've used DataMesh to map rows once I selected the columns in which the identifiers are. But for some reason, now DataMesh is leading me to map Columns only, not rows. It's like it's configured for an HLOOKUP rather than a VLOOKUP. Anyone know how this could happen? It feels like a setting issue of some…
-
Data Shuttle Dropdown Refresh with static value(s) not in source
Hi all, I'm looking to run a DS dropdown refresh but append the list with one or two form values not included in my source data, such as a "Not Listed" or "Not Applicable". Currently my source is a sheet content offload to excel attachment which has all the values I need, except these form criteria. If I add these in the…
-
Is it possible to have conditional formatting for a widget color or widget title color?
Is it possible to have conditional formatting for a widget color or widget title color?
-
January Question of the Month - Join the conversation and receive a badge
Hey there Community, I’m so happy to start 2025 with all of you. Be that you’ve been here for a long time (anyone close to 10 years?), or just joined today — thank you for being a part of the Smartsheet Community. If you’re looking for a chance to earn badges, and getting to know your peers, you’re in the right place!…
-
Data Mesh doesn't allow start and end dates when predecessors are enabled
If the project aims to transfer data from one sheet to another, automation could be a viable solution. However, there is a requirement that both sheets must be identical in order to facilitate the data transfer. At present, there is no available option for field attribute mapping, which would allow us to perform mapping…