-
Checking if Employee is active in a certain month
I am trying to create a function which calculates if an employee is active in a certain month, I have the start date and only have an end date if the employee has resigned. The function I have been working with is not working - Can anyone help? [April 25]1 - This is the cell where the date I am checking against is held…
-
Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
-
Power Automate and Smartsheet
I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's link text (instead of a long URL) and compose/send an email. I know Zapier can do this, but our team doesn't want to pay for…
-
Dynamic Dashboard Template Customization
I'm new to Smartsheets and learning by doing. Currently I'm working with the Dynamic Dashboard template to create my own Dashboard that filters for a given faculty last name, then pulls key details about them from a larger Faculty Information Sheet. I've worked out how to set a form that has a dropdown menu of all of their…
-
Welcome to the Financial Services Community!
My name is Chris, I lead marketing for Smartsheet for Financial Services and am excited to get to know you all! This is a space for Smartsheet users that work in Financial Services to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform Financial Services. Our Smartsheet team will…
-
Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Hi everyone, I've been experiencing an issue with an automation setup and was hoping to get some insights or solutions from the community. Problem When I configure automation to send an email alert to a contact after a trigger change, the system groups email notifications together even though each has a unique value in the…
-
I cant login on the iphone app
I created an account on my laptop using my Gmail account and started a project. I downloaded the iphone app. I tried to login using my email and password and the password is not recognised. I tried to login using my gmail account on the app and the project I started is not shown, It's like a brand new account. I'm unsure…
-
Data Shuttle source file is password protected
I am using Data Shuttle to import data into a DataTable from an Excel file that's password protected. After the workflow runs there's no data in the DataTable as a result. I've tested the same Data Shuttle workflow with a file that's not password protected, and it works fine. Is there a way to import data from a…
-
Join-Collect from dropdown?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
-
Resource Management Workload Schedule will not load
My resource management feature is functioning correctly within the extended license; however, the People Work Schedule and the individual project plan work schedule are not loading. My main concern is why the Workload Schedule does not display in the expanded view within the project plan. It is not loading for other…