-
sumif date is today to end of month
Trying to write a formula that doesn't need manual updating that basically sums a total amount for file that have a closing date from today to the end of the month. Seems like it should be fairly straight forward but I cant get it to work. The sheet has parent rows but i want to include all rows in all parent rows in the…
-
Feature Request - Mobile - Send Rows via E-mail (or Send Update)
I was wondering if there is something in the pipeline already for adding the Send or Send Update Request via the mobile app. This would help with our mobile team for providing or asking for updates from colleagues. Or if someone is already aware of a way of doing it. Thanks
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
RYG Roll-up
Hello, I am trying to create a formula that shows a green ball only if all children have a green ball. Thanks.
-
Construction Scheduling and Management
Looking for an experienced professional to set up a construction scheduling and management process with Smart Sheets. We are presently using Microsoft Project for scheduling. We need to increase the depth of our task and management items from 100+ to 600+. Need more interdependency control and clarity. Residential and…
-
User Management Reports Now Links to Zip Files?
Hi all, Did something change? It used to be, when I selected Download Sheet Access Report (or User List, etc) from the User Management > More Actions menu, a .CSV file with the name and date downloaded directly to my computer. In the past few days, that process has changed. Smartsheet is sending an email with a link to a…
-
Update requests not updating
Hi, Please can somebody help me with what seems like an easy process of requesting an update, but is not working. I have done selected the rows and cells that I require updated and sent them to an external stakeholder as per the documentation and videos. The first attempt did not actually update the Smartsheet, I had to…
-
Cell history copying prior entries
Hello. Is there a modifier key or some designation when making cell entries so they display with separate date stamps in Cell History? For example, when I add a note to a cell, the Cell History with the date stamp of my entry will include comments from prior dates, as well. I thought the History displayed separate entries…
-
Formula Help
This might be simple, but I can't figure out a good formula for dates. What I have is a column with dates, and another column (Year) next to it that is hopefully an If statement. Something like IF the date is in 2015 THEN put a 15. I need this column so I can reference this Year column when calculating total investments…
-
Calculation Formulas on Reports
Our company uses Smartsheet a little differently than most but I am finding it would be very helpful if I could add formula calculations directly to the reports I pull. Currently I have to add the formulas to the sheets themselves, hide those columns and continue dragging formulas down as we add rows. Hundreds of sheets...…