-
Can I link an entire sheet into my master sheet?
It looks like I need more than Cell Linking in our master project tracker. Do we have the ability to add a section on our master sheet so that any updates from a separate MARKETING TEAM sheet is displayed in the master sheet? I'm afraid simple cell linking only focuses on cells and won't take into account additional rows…
-
Activity Log Export
Is there a way to export the Activity Log once filtered? We would be able to use this for our metrics. It would be a huge time saver and really make SmartSheet that much better for us! I am sure this could be used in this manner for other companies as well. Thank you!
-
Using a modifier to derive month (formula de-bugging help
Ok. so I've set up a rolling dashboard built around the today function - something like this. Everything rolls over automatically as it all references TODAY() to determine the various derivatives. (see screenshot) It's great, but doesn't scale (yet). The Month column uses this right now - =IF((MONTH(TODAY()) + Modifier5) >…
-
Gant Chart Timeline in minutes/hours
Can i show my giant chart in minutes/hours rather than days?
-
New multi-select Field functionality, Feedback
I don't like that in resulting Excel dump from Smartsheet that values where I multi-select values, LOVs that resulting Excel filter does not have a space
-
IF Statements Date Range & Excluding Blank Cells
I need to build a status column that registers when any due dates in a project are nearing certain parameters. This is for projects that could have between 1 and 10 due dates. Formula at the bottom (it's a doozy). * Green if any due dates in a row are > than today(+7). * Yellow if any due dates are between Today(+7) and…
-
Bulk Upload of Contact Profile Data
I know I can bulk load contacts into Smartsheets for my account. But is there a way to upload full profiles? If so, what's the CSV format and where do I do this? Or - Asked a different way - If I include all of the contact info in the CSV file, will it import all of the data? Or only the "First Last Name" & "Email…
-
Help with formula to populate a quarter (text) based off date field.
Hello! I've searched many posts on the forum and can't find a solution. I'm at my wits end, any help would be very much appreciated! I am looking for a formula that will show a text result of Q#-YYYY based on an entry in a date field ("Expected Delivery Date", which is using the standard SmartSheet Date column. I can't…
-
How do I return a date based on a dropdown value?
Hi all, I am trying to work out a formula to get a cell to return a date based on a dropdown value. I need the cell to tell me when a matter is due, based on when the matter was received and the priority rating. the priority levels are (Service Type): * Fast track - 7 days * Basic - 14 days * Standard - 30 days * Complex -…
-
Filter Organization
Does SmartSheet have any way to organize filters? I have a large sheet where everything falls into one of five categories. There are then ten sub-categories for each main category. I would like to create filters for these 50 combinations, but I don't want to have my team users scroll thru 60+ filters. Ideally I would put…
