I'm a facilities project manager at an educational institution. We have begun using smartsheet for our project management tracking. I'm wondering if anyone has developed a pay application sheet they use in their applications. I think I could probably build one that will work but no need to reinvent the wheel if one already…
Text translated by moderator as per community is currently only supported in English, Spanish, German and Japanese. Hello everyone, I hope you are well. I have a question about an automation in my project sheets. One automation I'm implementing is an alert for when a certain project activity is approaching its due date. To…
I have been a smartsheet user for about 3 years. I started as a free user and moved into the licensed use and now I'm making sheets and reports like a pro! Thanks for a great product! :)
This discussion has been merged.
I have 5 different sheets representing 5 different projects in 1 program of work. So I am creating reports to bring those 5 sheets together to get a program level view. For one report, I want to see timings in a gantt view and color the bars based on the project sheet. However, I can't do this without changing the…
Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…
Is there a way to automate sending attachment (attachment in row) to specific e-mail, when a new row is added? Maybe through Smartsheet workflow, or Microsoft automate?
Is there a way to put a sheet into the dashboard that can be edited from the Dashboard?
Hello all, I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing…
Hello! I am trying to figure out how I can autofill a column in a RAID Log sheet based on the project name entered in a cell in the Project Plan sheet. What I tried: First, in the RIAD Log I added a "Project Name Helper" column and linked it to the cell that has the project name in the Project Plan sheet. I then added a…