-
Contact List - Determine if Email Is Missing
Hi! I have people filling out a Smartsheet form who are NOT licensed users and providing email addresses in a Contact List field for NON licensed users. I need to a way to know quickly if someone didn't follow directions and put their name instead of email into the form. I also have data already in the sheet where folks…
-
Autosave setting not working
Hello, My autosave setting does not seem to be work working, and I wanted to see if was user error, a bug or something else. I've updated my user settings to autosave after 1 minute, yet, it's not doing this. I've lost updates because of it. I sometimes get the 'it's been 10 minutes since your last save banner' (which has…
-
Selected data cannot be charted. Please select a new range error
Hello- I have charts on a few dashboards all set up the same, and they all stopped working. I tried creating a copy of the reports used in the charts but that doesn't help. Below is what one of the charts used to look like. It's a stacked bar graph showing the balance for the last available month and the $ in Foundation…
-
Billing
I have tried to downgrade and/or cancel my account. I've been contacting customer service for months now. The instructions they give me are pathetic, there is not an account icon on the bottom left. Smartsheet continues to close my cases without solving this issue. Perhaps someone who does not work for Smartsheet can help?…
-
Adding multiple summary sheet rows per project in control center
When creating a new project, how can I add multiple summary sheet rows per project in control center? For instance, a project has multiple funding sources, and I'd like to make a separate row for each project name/funding source combination in a summary sheet (not a report as the summary sheet needs additional columns for…
-
Duplicating a sheet and retaining formulas, mappings and automations
We have a monthly Tracker which contains a variety of automations, links to another sheet, mappings and formulas. We need to create a copy of this sheet to then use for the next month, but retain all the previous mentioned automations, etc. However, using the SAVE AS function does not allow us to do that. Are there any…
-
What happened to my critical path?!
Good morning Ss Community! I found some great answers, especially to this question: Why don't I see the critical path? — Smartsheet Community so I have already tried some of those suggestions: * sort by Start Date for chronological list of tasks helped the view but didn't fix my issue (see below for details) * task spans…
-
Is there a class/how to guide someone would suggest when using the policy template?
I am new to Smartsheet, but catch on pretty quickly. I did not find anything in the university.
-
What is the use of workApps and when to opt for it?
Hi everyone, I'm a new user, and my boss has asked me to research the WorkApps functionality in Smartsheet. After watching some videos, it seems quite similar to dashboards. Could someone explain the real use cases for WorkApps and how to determine if it's something we should be using? I’d really appreciate any demos or…
-
Help on creating an AGING using If, And Or Function?
Hi Help anyone, I need to compute an "AGING" when date today is past due date, and if the status is either "Yet to start" or "In Progress" I keep messing with the parenthesis…🤔
