-
SHEET SUMMARY REPORT - "columns to display" not showing up
I followed the video https://help.smartsheet.com/learning-track/smartsheet-intermediate/sheet-summary-reports as was trying to create a simple SHEET SUMMARY REPORT. I've created 3 sheets under folder "Sample Q3 Priorities" folder, when it's time to select the "columns to display" (ie. task name, % completed, status, etc…
-
Multiple sorts/countifs of different columns
Hello - new user here! I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'metadata-type' fields. I'm struggling to create summary reports of those 'metadata-type…
-
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…