Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Minutes of meeting
I am looking for a template to do minutes of meeting in smartsheet. The purpose is to pull out the tasks out of various MOM or other sheets and be able to pull a report for all my open tasks - no matter where they are. Minutes of meeting, to do lists, punch lists...
Dependencies
Hoping someone can help puzzle out a way to make this work! I'm trying to find a way to show the original estimate at the beginning of the project compared to the updated estimate based on how the project is going, without having to refer to the version history (so we can run alerts and formatting and such.) Essentially…
Backup Reports & Templates
Hi Community, I've got backups under control... BUT what I've found from various options / systems is that the reports can't be backed up. Has anyone found a way to do this?
Hours delay that changes made in sheets are also visible in reports
Hello Community, Our team of editors and other colleagues have made a big sheet where all the information on the testimonials that our members give is visible. From this sheet several reports were made. Since this tuesday, May 6, people noticed that changes made to the sheet are visible in the reports some 6 hours later.…
Reports Error
Hi all I have been using the same report now for a while and never had any issues tll now. I am running a report off a tooling equipment list and I have a date cell that automatically caculates when it is due for re calibration. The report I create is "if the recal date is today, overdue or in the next 28 days". Problem is…
Smartsheet error when opening a specific report
I am trying to open a specific report one of my teammates built that allows me to pull data from multiple Smartsheets. When I open the report, I get an error that the Smartsheet. com team has been notified. I checked in with my teammate that built the report and she said it is working fine on her end. Thanks for any help…
I'm trying to set up vacation time per resource in my project plan.
Is it doable in Smartsheet?
Is there a way to use cell references in an IF() statement?
I know you can use cell references in the "logical_test" clause but is there a way to use them in the "value_if_true" and "value_if_false" clauses? Al the examples of IF() statements have just text strings for what the IF() statement resolves to. I'd like it to resolve to the value in another cell. For example:…
Report Issues After Adjusting Order of Dropdown List Items
Hi everybody, I was wondering if anyone had any insight into the problem I'm experiencing. I have a master sheet with a column labelled "Departments." There was a long list of departments in that list which were what many reports were referencing. I decided that it would be easier to navigate if it was alphabetized, so I…
How do I link Cells to assign people?
In the sheet shown below I have some tasks assigned to specific people regardless of who is hired. Other tasks get assigned based on who the manager of the new hire is (see "manager" in the assigned to field). I have added a row for who the manager is (row 5). When a new person is hired, I would like to add the manager's…
