-
Spreadsheet with multiple tabs
I was maintaining an excel spreadsheet with multiple tabs, and some of the fields under these tabs were similar, when i would update this field in master tab, then it would populate the same informatoin on similar fields on rest of the tabs. I imported this excel spreadsheet in to smartsheet and it is importing only first…
-
Gantt timeline
Hi! I'm finding the Gantt timeline zoom options quite restrictive/extreme. Does anyone know whether there is way to either: - Zoom the timeline more variable than the standard extreme settings - Show 12-months' worth of timeline Thank you! Steve
-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Copying cards and substasks
Is it possible to copy cards and subtasks in the card view and have the new lines generated in grid view? Make sense? Im trying to copy all subtasks for a new card but just have the user update the main task name. Thanks
-
Auto format drop down menu
Hello everyone, I am trying to set an auto format for drop down menu to give select options from another column's drop down menu. Does anyone know how I can accomplish this? Example: If Assignment is Compliance give me the 5 specific compliance options from a list of 20 on another column. Thanks in advance,
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
Highlight Recently Modified Fields
Is it possible to create a condition that highlights only those fields that have been modified within a specific date range? I would like the highlighting to appear the way the notification email exclusively highlights new or changed fields.
-
Help with nested If formulat
These formulas work independently. I am attempting to combine them into one nested if formula. 1) if the %complete is full, status is green: =IF([% Complete]10 = "Full", "Green" , "Red") 2) if the finish date is greater thant today, status is green: =IF(Finish10 > TODAY(), "Green") 3) if %complete is full and finish date…
-
Subtasks in CardView
Hi Their I currently have 4 sheets which represent 4 departments in a card view ( running multiple kanbans ), off a card may come a subtask that needs to be delivered by another team. i am creating the subtask which creates the additional card on the main sheet, but when i move the subtask to the relevant department (…
-
Internet explorer stops working while trying to open an existing sheet
I have a new user that is encountering an issue when she tries to open an existing sheet. She retrieves an error that Internet Explorer has stopped working. she has to close and restart. the sheet is approximately 600 lines and looks like a standard project sheet. She is able to open other sheets without an issue but it is…
