-
Dynamic view @mentions - email not to take the user to the underlying sheet
the email notification to the @mention take them back to the underlying sheet, this defeats the purpose of keeping the user out of the base sheet. When the end user get the email notification, it should take them back to the dynamic view to add the comment.
-
Past Due Date in Business Day Formula
Hi! I have a formula I have been trying to figure out. I'm getting stuck because I want to make sure that the duration does not include weekends or holidays (if possible) and there is a condition. Any help would be appreciated. I would like to know how many business days past due a project is from today, but only if…
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an attachment. Currently my trigger for the workflow is when the data in a certain field…
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
-
Using COUNTIFS with CONTAINS
Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("Bernie Sanders", [Assigned]:[Assigned]), "True") The return value that I get is "0," which…
-
Merged: Lock Cell
This discussion has been merged.
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Populating a drop down from data in another sheet
Hello, I am in need of some assistance please! I am a developer and have been tasked with importing employee data into Smartsheet through the API. I have successfully built a C# service that pushes data into a sheet in smartsheet, my problem is they want to be able to auto populate a different secondary sheet (destination…
-
Does Smartsheet have a function to FORECAST?
I am looking to forecast a data set over a 7-year period in order to establish whether or not the organization is on-track to meet its targets. Is there a formula / function out there that can be used? Thanks!
-
What formula can I create to get the correct SLA?
I know I can create a column to only include the date from the ticket was submitted and another for calculating the business days. However, I'd like to auto-populate the deadlines based on the triage options. Based on the selection of Triage options auto-populate a deadline from the time the ticket was submitted: Tier 1 –…
