-
Let folders be folders!
Let at least JPEG/PDF files be uploaded to a folder without a sheet. It is assanin to have to create a sheet to add an attachment that you have to REDOWNLOAD in order to use/export. Why not just allow a folder to have a normal folder use and upload images if I can't even export the attachments off the sheet without having…
-
Can Smartsheets talk to each other?
I am new to Smartsheet. It seems super user-friendly, and I love that, but I don't have any previous experience with the software. I belong to a team of administrators who oversees the progression of an Apprenticeship Program within our organization. The process is lengthy, time specific, date sensitive, and very fluid.…
-
How to automatically remove "unmatched" datamesh results from the Target sheet?
Hi Smartsheet SMEs! In DataMesh, selecting the "Copy and Add Data" option will keep the Source and Target sheet in sync --- automatically creates new lookup values if needed. Have you devised a solution that automatically removes/deletes unmatched data --- rows in the target sheet that no longer reconciles to the Source…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…
-
Bulk allocation change in one way in Resource Management
Hi Team, We have a large number of resources in multiple projects. For us, it's very difficult to change the allocation when the project date has been changed. If you can work on this we can extend the resource allocation date in one way for all the resources in the single project it will help us minimize our effort for…
-
How to cross reference dates on a master sheet and then edit those dates on different worksheet?
Total noob here. I have a master sheet with 4 critical dates in regards to completing a major project (new restaurant opening). The critical dates are subject to change as some parts of the project are subject to be delayed due to construction, permits, etc. I would like to only have to change the dates on the master…
-
Do any other companies utilize Smartsheet for Weekly/Monthly Status Reports?
We are looking to move away from Excel based 'status reports' that are emailed each week to something that is more readily accessible and easier to manage/track. At a high level, each week an employee completes a status report on the projects/tasks they are working on or have completed. Our requirements would include: Have…
-
Employee Main List Formula Modification
I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a specific project phase (Dropdown). I am dividing the trainings by phases but I don't want the Trainings Attended to account…
-
Networking days taken from a start date and then one of two columns
I'm looking to find the average working days from the start date to the date of the job's first review. The first review could happen in two different ways represented in two different columns, a work in progress review, or an official review. Depending on the complexity of the job they may or may not need a WIP review. I…
-
Automate duration values based on a particular selection made in a form
I'd like to automate timings put into the duration column (shorter than days, e.g. 3 hours, etc.) based on selections made in a form submission to a sheet. Alternatively, setting up an automated workflow in the sheet that will automate timings in the duration column. again based on a particular selection being made.
