-
Linking rows
Hi guys, I'm new to smartsheet and I'm trying to figure out it can help me become more productive. So far, I have always used excel. I am working with a lot of minute by minute schedules tailored to the needs of the different departments in my company. I have one large file displaying all the small activities that happen…
-
Auto reply to a form
I was wondering if there is a way to have someone reply automatically to a form when asked for a reply
-
Upcoming Birthday Report
I would like to include a Report Widget that shows upcoming birthdays, but it doesn't seem possible to only pull data according to month and date (whenever I use the date column, it automatically adds the year -- 2018, in this case). Is there anyway that I can pull data for upcoming birthdays w/o relying on the year they…
-
IF Formula for a sheet
I am trying to get this formula to work correctly. I believe I am close however it is not working correctly. I have attached a screen shot.
-
Clickable Images - adding a hyperlink to an image
Wondering if there is a way to add a hyperlink to an image in a cell. The use case is a thumbnail of a web site in a cell that the user can click that will load the URL in a new browser tab.
-
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,