-
Are you able to change the third line down on a conversations email?
When someone is mentioned in conversations, is there a way to change the row it refers to (in this example: Row 40: Admin Lead QC - Prior to Technical QC) This is a task name I have added, but I am wondering if there is a way to change what column this feature picks up? Thank you, Alicia
-
Filter rows under parent row?
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue is submitted via the form for a High Priority. Have it automatically sort under the High Priority Parent Row? As of right…
-
Blank Data sheet but still sending automation
I was working on a page and doing some automation testing before it went live. I have a section where there is a drop down menu to select people. Using the form i have sent some automations to show them what it would look like getting the email but even though i have deleted the data from the sheet, they are still getting…
-
Using CONTAINS or LEFT in a COUNTIFS
I am trying to create a helper column to flag when there are not enough safety cones in a vehicle depending on the vehicle type. For example Pickups need 6 minimum, Vans 8min and Buckets 12min. The types vary with PICKUP/FORD, PICKUP/CHEV, Pickup - Service Body, and Pickup. My first thought was to do a contains in the…
-
Task completion (%)
Hello everyone, is there a way to set the % complete based on the task status? I have a table [state ; % complete] I tried with "VLOOKUP" function but isn't possible to insert formulas in the field. Help me please! Thanks
-
Automatic formula
Hello everyone, In some fields in my sheets I have formulas. Is there a way to automatically report these formulas when I add new rows? Thanks
-
Onboarding Template Questions - HR
Hello! Has anyone used the Onboarding Template for New Hires in Smart Sheet. We are trying to figure out the easiest way to duplicate the sheet for new hires and have them all roll in to one dashboard. We noticed another user commented that using the Project Template worked for him for onboarding new hires. How are you…
-
Formula to Copy cells if no match?
I'm looking for a way (probably some sort of Index/Match formula?) to check for a customer name on 2 lists. If the name shows up on the second list, but not the first, add it also to the first list. Here is our specific set up: The first list is a workflow tracker where most people will start. The first step in the…
-
How can I create a material inventory and order form in the same sheet
Hello, I am very new to Smartsheets and am trying to streamline inventory and how our partners order materials from us. Currently, partners email members of our team and someone fulfils and tracks the order manually in an excel sheet. I want to create a sheet that tracks inventory with an order form that subtracts from the…
-
Trouble reaching a human
Hey all, I made a mistake in registering for some training at SmartSheet University. It has been like 2 weeks of trying to contact a human to resolve my issue. I have opened tickets, left messages, sent emails, .... and not 1 person has reached out to me. Do any of you have any suggestions trying to contact someone? I…
