-
Attach checkbox column in the source sheet to a specific user per row.
Hi! I am trying to create DVs from this sheet that will do the following: In this screenshot example - Elizabeth is the roadmap owner, but Deb is the Calendar invite owner. So in Elizabeth's DV, I still need her to be able to see this row, but not be able to edit the Calendar Update Complete column. In Deb's DV, I need her…
-
Can you have a column showing a driving predecessor for a task?
In my job as a scheduler a common question is "which of the predecessors for this activity is driving the date?" Currently I have to rely on my own knowledge of my schedules or, worst case, I have to look at every predecessor until I find the one I am looking for. Microsoft Project is nice because it has the "inspect"…
-
Automation - triggered within a set number of days before a date
Hi everyone! I need to set up an automation that is triggered within a set number of days before the date listed in a date field. I need the automation to send an alert email to a new hire at most 7 days before the start date. I know I can set the automation to send 1 week before the start date, but if the new hire's…
-
Speedometer Chart: Core Product
I've noticed a few people asking for Speedometer Charts in Smartsheet, so I figured I would go ahead and publish this solution that I developed. It was some years ago, so there may be better ways and / or more efficient formulas, but this should at least help get everyone started… A few notes to kick things off… This…
-
Linking Auto# Columns
I have 2 sheets that I need to link: Sheet 1 - collects user registration information through a form. Sheet 2 - I want to link some columns to copy partial data collected in sheet 1 and have it show in sheet 2. I don't want to copy the entire row, just select columns and I don't have Smartsheet Bridge. Each sheet has a…
-
Shortcut to Dashboard Header / Bookmarks
I have a pretty big dashboard of resources that are grouped under 9 headers. The top of my dashboard has a table of contents. Is there anyway to link a jump to those headers within the same dashboard? A link to a bookmark within the dashboard (not to another sheet)?
-
Graph Question
Can someone tell me how to get rid of the 120.0% max on this graph? It is always going total 100% and never any more, so I would like to use more of the space for graph display purposes. I even tried reducing it so that the largest value was 99.999%, thinking maybe being exactly 100 would cause the next "level" to…
-
Android app not syncing with web or windows app
The Smartsheet app on my Samsung phone (android) is logging in perfectly and showing all my sheets etc, but when I try and log in to my account on the web or windows app it says I have a trial account and now sheets are showing - what am I doing wrong, is there someway I can get them to sync with my android app??
-
Duplicate rows
I have been using the API to send rows to sheets. Recently I have seen single row submissions showing up as duplicate rows, randomly. Not always. Has anyone else been seeing this phenomenon, or do I have some sort of bug in my code. Using .NET SDK.
-
Problems with turning off automatic backups
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?