Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, WorkApps, or Resource Management. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Unable to choose workspace for blueprint to create tempaltes
I have a blueprint in place that creates brand new workspaces for projects, and it all works well. I want our PMs to submit a request to drop a different set of templates in a new folder created under an existing workspace. The PM wants to be able to select the workspace of their choosing. So i created a separate…
Data Shuttle Not Adding Net New Entries
Hello! I have set up Data Shuttle with the intention that the PM on the project can attach the daily issue log she receives from our IT department and her sheet would be automatically updated. She document she receives from IT is an .xlsx spreadsheet. I noticed that with each new attachment, the existing data would be…
Help with Document Builder Mapping
Hello, I'm trying to set up a DocuSign template, but get stuck at the part of selecting a template with this error message. Does anyone know what this might mean? Any guidance would be appreciated! Thank you!
年代yncing Smartsheet schedule and Resource Management
Y'all I've switched on the Resource Management module but schedule tasks and assignments are not being synced across to the RM module. Is there anything I need to do in the RM module to have this done? Thanks. Nyasha.
Actions Button for Slack Integration
I am recently working on a workflow while utilising the slack integrations, particularly with notifications. However, I have seen that there can be actions set as part of the slack notifications on the smartsheet site (more specifically action requests (decline or approve)), but there is no indication this process can be…
Dashboard integration with powerpoint - or print preview function
Currently to load our projects from a dashboard to powerpoint we 'print to pdf' and then snip to paste to power point. Is Power point integration a reality? If not is a print preview function possible to clearly show where each page cuts off? This is a monthly cycle for my team to reformat/respace depending on the amount…
Dynamic View Comment Emails
We use Dynamic View for our sales force and customer service reps. They each have their own respective view that is connected back to the main sheet. Our design department uses the main sheet to process incoming requests via a form. We have run into an issue with links in automated emails using the…
Default view card or calendar for Teams integration
Hi there, I attempted to see if there was a solution for this out there, but no such luck. Hoping this group may be able to help... I recently integrated some sheets to a Microsoft Teams channel. The sheets in question when shared in Smartsheet are Card view or Calendar view rather than the standard grid. When integrating…
Checkbox not appearing Dynamic View
I have a checkbox that for whatever reason is not showing up in a view. The field is not restricted or hidden. The view contains 15 logical statements based on specific field criteria, nothing hiding the the field. In fact, I have one statement that even makes it editable just to test this. Is there a limited to the number…
Pulling Youtube Views Into a Dashboard
Hello! Our marketing department would like to track the views of multiple youtube videos in a smartsheet dashboard. Has anyone had any success with this? I'm not seeing a way to import information from youtube analytics. Thank you!

Popular Tags

12]1, 1) =(NETDAYS([Reference date of a Monday (Used for Calc 2)]@row, [First Day of \"Month of Next Event\" Part 1 of calc]@row) - (7 * INT(NETDAYS([Reference date of a Monday (Used for Calc…","categoryID":321,"dateInserted":"2023-05-22T08:55:50+00:00","dateUpdated":null,"dateLastComment":"2023-05-22T09:26:10+00:00","insertUserID":152702,"insertUser":{"userID":152702,"name":"Andrew McCrae","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20McCrae","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-22T10:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-22T13:22:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":25,"score":null,"hot":3369495120,"url":"https:\/\/community.smartsheet.com\/discussion\/105523\/how-to-add-an-absolute-reference-and-have-a-column-formula-without-cross-sheet-references","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105523\/how-to-add-an-absolute-reference-and-have-a-column-formula-without-cross-sheet-references","format":"Rich","lastPost":{"discussionID":105523,"commentID":376895,"name":"Re: How to Add an absolute reference AND have a column formula without cross sheet references","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376895#Comment_376895","dateInserted":"2023-05-22T09:26:10+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-22T13:22:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/1Z6C2T1T0S4D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-22T10:09:18+00:00","dateAnswered":"2023-05-22T09:05:55+00:00","acceptedAnswers":[{"commentID":376892,"body":"

Got it to work. Sometimes in formulating a question, you are forced to think. I changed the formula to eliminate the reference by putting a fixed date like follows. I am sure I could make it more elegant but it is working for me it appears.<\/p>

=(NETDAYS(DATE(1900, 1, 1), [First Day of \"Month of Next Event\" Part 1 of calc]@row) - (7 * INT(NETDAYS(DATE(1900, 1, 1), [First Day of \"Month of Next Event\" Part 1 of calc]@row) \/ 7)) + 1)<\/p>"},{"commentID":376895,"body":"

Hi @Andrew McCrae<\/a> <\/p>

I hope you're well and safe!<\/p>

Excellent! Glad you got it working!<\/p>

Be safe, and have a fantastic day!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Hi @Umesh Shah<\/a> <\/p>

Hi @Solar Eric<\/a> <\/p>

It's actually the other way around: if you are licensed on a Business plan, you can share your sheet to Free collaborators (users without a license) or Pro plan users and they can <\/strong>edit and collaborate. This is because the sheet is Owned by a Business plan. <\/p>

However if a licensed user on a Pro plan creates a sheet, only licensed members of their specific<\/em> Pro plan can edit their sheets. Everyone else shared to the sheet (Free collaborators and licensed Business plan members in a different plan) will only have View<\/strong> access to that sheet. This is because the sheet is owned by a Pro plan member with limited sharing abilities. Here's more information: Sharing and widgets in the Pro plan<\/a><\/p>

<\/p>

Point form:<\/p>