-
Multiple filters
Hello community, I am a newbee to Smartsheet. I am creating a content pipeline for our unit and am looking for a way to apply multiple filters to one column. For example in my "Audience" column, I would like to filter for each individual audience (we have about 30 in total) but if possible also for two or more audiences at…
-
Formula: Start date + 1/2... days
Hello community, I am trying to add a formula for the following: The date in red is the start date (DATE1). The dates below should be programmed like DATE1 + 1day, DATE1 +2days etc. I tried different formulas I found in the Learning Center but for some reason it didn't work... Thank you for your help! Elizabeth
-
Do Personal Settings apply to all sheets you are shared to?
If I change my Personal settings, not to receive notifications for Sheet Changes and Reminders, does that apply to every sheet I am shared-to.. or only the Sheet I was logged into, when I changed my Person Settings?
-
Automatically work out Contract Expiry Dates
Hi, i'm trying to write a formula that will automatically work out the expiry date of a contract any given number of years in the future. If the 'OSD' is the start date and the contract runs for 8 years this is fairly simple e.g. OSD - 01/10/12 then 8 year anniversary - 01/10/20 (UK date format) using formula:…
-
Group Management doesn't pull from My Smartsheet Contacts anymore
I am using the new (preview) Smartsheet Admin Center "Group Managment" interface. In the old version when I wanted to add someone to a group, the "Add Member" picker would allow me to add users from our account and from My Smartsheet Contacts. It no longer does that and the picker only looks for potential new members from…
-
Trigger Conditions
Hi I am really struggling with the trigger field and options! I've got a workflow that triggers when a row is added or changes. Part of the process for declining, and requesting further information, will not trigger again in the workflow back from the start. The original trigger field, in all the training I see online with…
-
Inconsistency in how contacts are displayed across sheets
Hi, I have noticed inconsistency in how same contact is displayed differently across sheets. In one sheet it is displayed as name whereas in other sheet its displayed as email id. I understand that in one sheet where its displayed as name, its picking up the name from user name in my smartsheet account. But in other sheet…
-
Temporary special covid pricing for covid impacted individuals
Hi there - I was made redundant due to covid pandemic recently, and at this time, I am trying to learn smartsheet as part of my personal self development. My trial will be over soon, but I wanted to see if there's a special pricing an individual can get to continue learning from this, as I am also trying to be sensitive of…
-
Action needed: Add new Smartsheet email domains to your trusted sender list
Hi Smartsheet Community, In the coming weeks, we will start a transition to begin using three new email subdomains to send emails generated by our Smartsheet app; such as automated workflows, sharing, conversation notifications and password resets. We are making this change to follow the email sending best practice of…
-
conditional formating is not working
Hello! I am unable to determine what is preventing this simple conditional formatting rule to apply to my sheet. There are two in the image below. The orance/emergency request works perfectly. I was able to confirm that the common issue of task bar was not selected/configured (screenshot). Can anyone offer other…
