Product questions?
Ask it here! The community's got your back.
Discussion List
Calendar app
Hi, I have a calendar app built on top of a smartsheet. Currently, the calendar app displays all the rows in the smartsheet grid. Users are able to add new events into the calendar app. My question - Is it possible to have view only access to all users except the admins but still be able to add new events to the calendar?…
Is there a way to connect Confluence with Smartsheet using AWS?
I want to pull data from Confluence and move it to Smartsheet using AWS but I am not sure if possible. Does anyone have tried this before? Thanks
Power Automate & Smartsheet
Hello everyone, I'm currently working on a project involving Power Automate to create folders in SharePoint whenever a row is updated in Smartsheet. I want to use the updated value in a particular cell as the new folder's name in SharePoint. I've been following these instructions, but I'm having trouble finding the "Get…
Document Builder checkbox format
Hi I've been using the document builder with a PDF that has a lot of checkboxes. When the document is generated, all the check marks are out of place and also in with a trace I did'nt add in my PDF editor. I checked all the format options in the PDF editor and also test two other editors to discard any program…
FIND/REPLACE SCC for Sheet Summary Information?
Is it possible to update sheet summary information using the find/replace global update in SCC? My hunch is no. Thanks!
Resource Managment
I'm having an issue that when employees are showing up as booked on projects, they are not being calculated in the analytics report. This is sporadic and not consistent across all employees. For example, I have an employee that is assigned to two projects, and they both show up on the schedule, however only one shows up on…
Hyperlink in Cell Isn't Greyed Out When Checkbox is Selected
I have a conditional format setup on my sheet to grey out a row when the checkbox for row is checked. However, the link that I have setup in one of my cells doesn't grey out. Is there a setting I'm missing for this?
Using DataMesh For Status Updates
Hey all - Looking for a little help here. I've been using a combination of DataMesh the Copy function in SmartSheets to make a copy of a row when it changes to a particular status. Let me illustrate what happens here. I have two sheets connected to each other. Sheet 2 (below) does a vlookup to Sheet 1 to get the status (I…
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
ColabSoftware.com
Anyone using https://www.colabsoftware.com/ along with Smartsheet? We likely will be using ColabSoftware side by side with Smartsheet and any tips and tricks would be appreciated.