Admin@PAT✭

Hi Travis, Likely th ebest option is - as above to 'link' the smartsheet within the sheet you wish to reference. You can add a hyperlink within the sheet - in a cell that you can click through with. Alternatively by adding a 'comment' and typing - copy and paste - the sheets webpage - this will create a link not visible on…

Hi Soumya, The Function you will need is =JOIN - this is SS 'concatenate' solution.

Grant - same as the checkboxes - add a "." fullstop and make the font the same colour and the rows will appear 'clean'.

Yes. I have a smaller version detailing services against Engineering Resources that shows when each resource is booked, and is colour coded accordingly for quick reference. In CF you can allocate that if "Course Name" is, contains etc change the colour of the TASK Bar, this will not show in your sheet, but will show the…

To show Year Day of TODAY use this: =YEARDAY(TODAY())

Once you create the Template you wish to use, simply Save as Template using the little arrow in the Sheet Tab - then you can use this as a starting point for new projects moving forward. You are prompted to save as (name) and destination - I have a Folder simply called Templates I refer back to.

Ho can I do this in a report?

Hi Y I have flipped your thoughts around and found that maybe this will help - it will greatly reduce the lines of CF you will need - hope it makes sense, you can simply CF based on the colkumn it relates to rather than each individual line being different.

Hi again, Have a poke around on Youtube and the Smartsheet Webinars (you will find the Webinars link below in the blue footer on this page). There is also Videos, worksheet and guides galore in the Help/Support Centre. While these mig thbe quite involved, it will offer a great visual tool to give yu an idea on how to…

I'd love to know more about this also, still trying to wrap my head around it all. I'd love a calendar type option, similar to Outlok calendar with room allocations to show availability aswell as bookings.