-
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…
-
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 –…
-
Help with IF AND formula with cross sheet reference
I am trying to write a cross sheet formula, and I keep getting an #INVALID OPERATION error, and I cannot puzzle it out. My current formula: =IF(AND({Scenario REQ ID} = [REQ ID]@row, {Scenario Status} = "Pass"), 1, 0) If the REQ ID from my scenario sheet matches the REQ ID of this row, AND the Status on the scenario sheet…
-
Adding a New Sheet to an Existing Summary Report
Hi there, I have a workspace tracking our grant applications using the Multiple Projects template. Each grant has it's own sheet for tracking the application process, implementation and reporting. The "Report - At Risk" and "Report - In Progress" reports are only pulling data from the original sheet I created. I've tried…
