-
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…
-
How do I calculate the difference between 2 dates?
Trying to track variable durations of past projects and simply want to subtract the start date from the completion date... depending on which format the column is in, I get various errors. Seems like I should be able to simply subtract one cell from the other, no?
-
Opening a template by selecting a check box or status field
Hello all, I am very new to Smartsheet so please excuse the question. I know how to do the following in excel but haven't found a way to do it in Smartsheet. I have a list of courses that belong to certain programs. I would like the program chairs to select the courses they would like for my team to work on by selecting a…
-
Successors
I have read the comments on Successors from Nov , 2015 Has a successor column been added and addressed this issue? The comments made as to having to manually put those numbers in is totally inefficient since there are other programs out there that will do that automatically. Please advise. Thanks Rick
-
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.
-
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!!!
-
Best way to add data to a project
I have all kinds of data to add to a project, .From address to the people outside the group who's information we need. Size of building, no of seats, building inspector name and contAct information etc. I home one project smartsheet per project
-
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…
-
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 -…
-
Nag an approver?
Is there a way to send a repeat approval request if the initial request goes unanswered? Kind of like a, "while 'Jane Q. Ceo's' approval status is 'Submitted' send an update request once a day." Then, of course, once it changes to approved or declined, the notifications stop. It seems like all of the notifications or…
