-
Why is this happening all of sudden?
Hi all, I have had an automation set up (and working fine for quite some time) that copies a row to another sheet and then moves that row to a different sheet (Archive) when "send to Archive" is checked. As stated, this workflow has been performing perfectly for several months. Nothing in the source or destination sheets…
-
Fleet Follow up
Hi All, I am looking for a fleet follow up. the difficulty i have is that 1 Truck or trailer can have multiple type of inspection and also multiple dates. For example TVP62 ( truck number) First one is Technical inspection + service Appointment date garage is 29/09/2023 ( date when the unit needs to be at the garage) End…
-
Using Attachments from a Sheet
Is it possible to populate a dashboard by using the attachments from a sheet? Regards, MaW
-
How to Count a value in a drop down / multi-selection list?
Hi, I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…
-
Equipment Booking/Reservation System
This has been asked before but I haven't seen a solid solution yet... I manage outdoor equipment inventory that can be reserved by employee's (things like tents, boots, etc) on a seasonal basis. I've already created a sheet that contains all available inventory there is to reserve, as well as a separate, basic reservation…
-
Two jobs in one spreadsheet?
Hi, Thanks in advance for your help. I have two sets of duties within my position: one set as Sustainability Engagement Coordinator, and one as Energy Coach. How can I use smartsheet to track the amount of time I spend each week on work for each set of duties, and track projects on each? Or do I need separate sheets for…
-
Changing File Directory for downloaded attachments
Hi all, For context, I use a Form to manage incoming service requests and generate PDF Work Order attachments. I would like to change the file directory for downloaded attachments to a shared folder rather than 'Downloads' so my supplier has visibility of the work orders when they are assigned. I can't seem to find an…
-
Colour-coded labels on a Kanban
Hello community! We're in the process of moving our Kanbans from Trello to SmartSheet (which is new to all of the team). From this article I understand it's possible to use colour-coded labels on a SmartSheet Kanban; however, I'm unable to find this feature nor any documentation on how it works. If anyone can help that…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
-
2 system generated auto number columns
Hi Team, I have sheets from different departments that have auto generated numbers in them. What I’m wanting is when the sheets are copied to a master sheet, I want to have another system generated number as a unique code. But I can’t get it to work. I need each department to have its auto number, then once moved to the…
