-
Workspace Panel Icon Disappears - how do you get it back?
I love the new workspace panel. The challenge is that once I access a different worksapce through browse, the panel icon disappears, and I can't figure out how to get it back without selecting a workspace in browse, then editing the URL to delete the text "/browse". Is there a way to access the panel from browse for other…
-
How can we have a drop down in Dashboard
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks
-
Need to find average value for a column in sheet summary; contains number and text.
We have (5) survey questions with a number and description: 1 - strongly disagree; 2 - disagree, etc. I need to find the average in the sheet summary; what is the correct formula to extract the text portion and only retain the average of the numerical value? Thank you!
-
Separate reply-to email address for auto emails
Hello, I'd like to vote for the feature of a separate reply-to email address when setting up auto emails. I'm the owner of a large number of sheets, and despite it not necessarily being a problem that emails appear to come from me, i'm having a huge issue with the large number of replies i receive. Despite adding text in…
-
Sheet Task bar colours are only sometimes transfering to sheet timeline view or a report
Hello, I am a new user, in a trial of smartsheet using it on Firefox. I welcome all advice or tips. I have a source sheet of data. I created a new sheet pulling in some data and adding in dates to make a timeline. I have colour coded parents on the sheet 1st two coloums. Those colours have transfered over to the timeline…
-
Dashboard
I have a metrics sheet that I send every Monday to leadership. However, I'm finding that I need to look at prior weekly metrics for comparison. Since my metrics sheet updates constantly, how would I capture that data without having to log it manually each week? I know this is a vague question. My formula knowledge is…
-
One single form to show certain fields to specific users
This discussion was created from comments split from: Hidden Fields and Update Requests.
-
TIP: Calculations on an AutoNumber Column
I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000. You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT…
-
Workflow - Acknowledgement with Submit option
Hi Team I have a scenario wherein a Form has been created to be submitted by Manager to provide feedback to their team member. All we need is that once the manager submits the form, it should get routed to the team member who get a notification, can access the form and "Check Box" acknowledgment and hit submit. The form…
-
Flagging dates overlap
Hi Smartsheet stars, I try to flag jobs overlaps using COUNTIFS function as per screenshots below (tried two different options), however, it doesn't show me 3 overlaps I currently have in my Smart sheet (I created a new A and AAA projects with conflicting dates but it has not been flagged for some reason). Could you please…
