-
Control Center Project Plan doesn't update Master Summary Rollup sheet until project plan is saved.
I have a formula on the project plan template which uses the TODAY() fx to identify when tasks are at risk because they are overdue. Project plans are linked in Control Center to a master rollup. The risk flag doesn't link until the project plan has been opened and saved. Is there a fix for this? The problem is the…
-
Dynamic View Sharing
I want to share the view based off of the contact column in the source sheet. The contacts added to the source sheet are all external clients. Is there a way for me to share the view to all contacts in the source sheet column and for it to automatically update when new contacts are added? I want the client only to be able…
-
Logged in user filter on report in WorkApp
I have a report that is filtered by the logged in user. I have published that report to a WorkApp. My user can see all users' information on the report via the WorkApp, not just their own. However, if she looks at the sheet directly in Smartsheet, she only sees her information. Is there a trick (like the "Dashboard Viewer"…
-
Smartsheet Merge with Google Docs add-on
I have text wrapped turned off in my sheet. However, when I use the smartsheet google doc add on and get to the select row window the preview window shows rows with much large cell heights - it does wrap the text in the preview window. I would like the rows to be close together instead of large spaces. Is there a way to…
-
Calendar App for Shared Resource
Has anyone used the calendar app to book/schedule a shared resource (conference rooms) across different organizations? If so can you share some details?
-
Smartsheet - Azure DevOps integration
Hey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a row is updated in Smartsheet (and vice versa)? My goal is to be able to update fields in…
-
VLOOKUP #NoMatch has me completely stumped
I have a vlookup formula in my sheet (Project Plan) that references another sheet (Phone List). Despite triple checking formulas, spelling, spaces, etc. I could not get the formula to return anything by #No Match. I copied and pasted the original sheet (Phone List) that's referenced into a new sheet (Copy of Phone List)…
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
-
Live Data Connector changed Modified Date/Time?
I use the Live Data Connector (LDC) to pull data into an Access database. I wasn't seeing some recent changes, so I wrote a query to find the MAX of MODIFIED, and I was surprised to see the MODIFIED field through the LDC hadn't happened yet! It's 10:30 AM here (USA Central) and the LDC is telling me that my records were…
-
Can I send a row to whatsapp
This is an essential feature, it's going to add much value to smartsheet
