-
Email daily comments on (multiple) sheets
This seems pretty basic, so not sure if I'm missing something. But, certain project stakeholders like to receive daily status emails that show the project activity. When I say activity, I mean comments, not who changed which cell. Currently the only way I've been able to do this is the literally grab screenshots of the…
-
Reports Using Start Date Criteria
I am trying to build a report that shows all projects by quarter - those that start after Dec 31 and before Apr 1 would pull into my Q1 report, for example. When building my criteria I only see to have the option to choose starts after Dec 31 OR starts before Apr 1. I need to change this to AND, but don't see an option for…
-
Column Not Found
Hello! When I am filtering down information from a sheet into multiple reports, a few of my columns are labeled as 'not found'. I haven’t renamed the columns, which I understand could cause this -although on one of the columns I changed the column type from 'symbols' to 'text' fairly recently (but not for my other one).…
-
Redirect smartsheet links to the published link.
Hi there, Hopefully you guys can help me with this, as it would be something that would really help me out with the way my company uses smartsheet. I have a template workspace I've put together that contains portals / dashboards with links to other portals / dashboards, that are also within the workspace. The way copying a…
-
Function Help
How would I go about trying to create a formula that scan down a column finding and grouping the same "assigned to" and then grabing that specific %cost and totaling them up in another cell?
-
=DATEONLY VARIANCE COUNTING WEEKDENDS
Hi, Trying to use the =dateonly to get the variance between planned start and actual start, but it looks like the calculation is counting the weekend days when in only want it to count weekdays. Is this possible?
-
"Persistent", one-time date function
I'd like to see a function like "TODAY()", or cell behavior that supports it, that executes only once when an event is triggered so that the date result that never changes. My use case is a Card view Kanban board with status states: Ready, Dev, Test, Deploy, Done, and matching columns for their start dates, e.g. Dev Start.…
-
Portfolio Management
Has anyone used Smartsheet as a portfolio management solution?
-
Out of Office Calendar - recurrent events
We want to use Smartsheets to set up an out of office calendar for vacations, work trips, working from home etc. We are capturing name, dates, and reason for being out of the office. We planned on having staff enter in OOO on a form and then have the calendar show on a dashboard so it is easy to know if someone is out.…
-
Outgoing Links Not Working Since Update
Hello, I have been experiencing issues with my outgoing links not working since the last update. If I change the data in the outgoing link, it points to the correct cell, but the data is incorrect. The only way I can fix it is to delete the links and then add them again. I do not have the time to do this for all of my…
