Smartsheet Basics

Archives for August 2019

Looking for a template option
Hello - I currently work with a spreadsheet that has multiple TABS - I am looking to move that spreadsheet over to Smartsheets and I was hoping someone could offer a template I could use. I have 6 different TABs - each tab has about 30 columns and 20 rows. (It is a multi-layered event planning checklist of sorts) Any help…
Show Minimum date of children, if blank put a dash
I'm having an issue with a sheet I am working on. I want a parent row to show the minimum date of the child rows, "=MIN(CHILDREN())" which works fine. However if there are no dates yet, I want the cell to display a dash "-" and for the life of me I can't get this work. I have tried using ISBLANK but I don't think I am…
CONDITIONAL FORMATTING FOR DATE TYPE CELL
Greetings, I have two rows with multiple date type columns. I need to added a conditional formatting where, if the date in row is greater than the date in other row, the cell with greater date needs to be highlighted. Someone Kindly help. Thank you
Most recent date for specific asset
Hello, I have a list of equipment with the calibration date and schedule regarding our internal requirement ( 3 month, 12, 24..): this sheet is my Calibration schedule. I also have a form that employee will use to record each calibration operation related to lets say a serial number. This sheet is my Calibration Log. What…
Repeat reminder on single task
Hi Has anyone used the new workflow to set up a daily reminder on a single task (row) until it is completed? I dont want to use % complete or date triggers just literally a daily reminder on a single tasks that is due to be completed with a daily reminder until completed. I have tried a few combos but not able to find a…
reminders sent more than 30 days but less than 60 days prior to an event
I want to set up a reminder to occur 6 weeks prior to an event. The pull down menu choices of timing give me a maximum of 4 weeks or 30 or 60 days? How do I schedule it 6 weeks or 42 days prior to the event? Thanks!
Sheet Summary
Has anyone started using this new feature? It's unclear to me what it is this summarizes. How are other using this, any examples?
Auto-Number on Certain Rows
Forgive my naivety as I'm still green at formatting. I'm trying to use the Auto-Number function in a column. I don't want all cells in the column to populate - only if column c isn't blank. I can't seem to get this to work where the auto-number will popular a cell if column c contains anything?
Hide source sheet of a report but still allow users to input information into the report
I'd like to find out if there is a way to allow shared users to make edits to a report, but never be able to access the source sheet the report is generated from. Right now, it seems like I have to give users access to both sheets at the same permissions level but I only want them to be able to access the report and not…
Grid with hyperlink
Hi have a smartsheet grid that lists a series of reports. One of the columns is a hyperlink to a sample of the actual report. The hyperlink shows up if I open the grid. But when I report on the grid and include the report in a dashboard, the link is not active. How can I display this list of reports from the grid so the…

Trending in Smartsheet Basics

Can the Smartsheet Calendar App send a notification when an event is added or updated?
Wondering if it is possible to send notifications via Smartsheet when an event is added or updated to a Calendar in the app…
Alert Someone 1 Week Before Due Date
Hello Smartsheets Community, I'm sure this is a dumb question, but I can't figure it out and need some help. I need to create an alert 1 week before dates that are entered in a date column field on my sheet (example below). I tried creating an automation, but I don't see where I can select # of days prior to a date. Any…
Gantt Chart - Limited range
Hi All, hope everyone has a great 2025. Noticed this morning Gantt view now only scrolls right to furthest project end date whereas before it was endless? at least I'm sure it was…. Annoying as looking to confirm Non working dates saved in settings for the year are displaying the coloured column. Further, @Genevieve P. Is…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List