-
Calendar View Conditional Formatting
I know how to set conditional formatting to the row for the calendar view. However, I want to format more than just the taskbar color. Is there a way for the font, bold, and underline to also transfer to the calendar view? I am attempting to differentiate two tasks by font, etc. with the same task bar color.
-
Event Registration - Link to Webinar
I'm using the Event Registration template for people to sign up for a webinar and I'd like to send registrants a link to the webinar after they register. The only way it works is if I include the option to send a confirmation. BUT, the person registering has to click that box and I can't make it a required checkbox. I know…
-
Feature request: Cell Linking still linked when to you click 'Go to the Sheet'
So when your linking cells across sheets, I'm trying to link SheetX with SheetY (which has the attachments I need), I can link the site names between the sheet, when the preview screen pops up to show me SheetY (exactly where my site is linked) but I can't download the attachment from this preview screen, then when I click…
-
Default a value in dropdown list??
I was just asked if there is a way to have one of the values in a dropdown list be the "default" value. My gut says there is not, or I've had done this a long time ago, but wanted to ask the community before I say No.
-
Gantt Chart Revenue Forecasting
I've built a sheet with all of our active projects and am wanting to predict revenue. I am wondering if I can add expected revenue to milestones in a gantt chart and have it report monthly expected income as a report or on the chart itself somehow? I really just need a monthly total of expected revenue as I pile more and…
-
keyboard short for inserting comment
First post. Love Smartsheet! Did some searching, but came up blank.... I'm typing away managing my first big project in Smartsheet and am adding a lot of comments. I'm clicking the mouse to bring up the Comments dialog. At least I can <TAB><SPACE> to tab to the post button. You're already doing better than google in terms…
-
Send notifications "daily" or "weekly", but not in middle of night
Is there a way to not have smartsheet notifications sent at 2:00am? (e.g. on call people have to have their email notifications audible 24/7) I'm afraid the time of day these types of notifications are sent are set on a global level, correct? Any workarounds? I would love to be able to have these be sent daily at 8:00am -…
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
-
count number customers briefed by quarter
Hi, I have a date column which shows the date we briefed a customer, I want to determine how many customers we briefed in each quarter and eventually by month. The column property is "date" and I cannot change that. =COUNTIFS([Date Briefed:Date Briefed], >DATE(2017,07,31), [Date Briefed:Date Briefed],<DATE(2017,11,01)) I…
-
Copying rows w/ checkmarked cell to different sheet
Hello, I am trying to find a way to link rows between sheets, but the 2nd sheet should only show the rows from the 1st sheet with a checkmark in one of the columns. Sheet 1: list of skus with descriptions and details. One column has a checkmark for the critical skus Sheet 2: auto copy (i.e. link) only specific columns for…
