-
Export of Reminders
If I have multiple reminders set up in my Smartsheet, is it possible to get an export of all the set reminders together with the content/message I have written?
-
SUMIF formula for adding up in a date range
I have a sheet that I am using to collect a list of items weights and have multiple per day. i want to capture all the weights that are today and for the next 5 days and sum them up if possible. Currently i have tried this formula =SUMIF(Date:Date, <=TODAY(), [Qty (ton)]:[Qty (ton)]) but this includes all the past dates,…
-
Masked link in email notifications?
We use Update Requests a fair amount on our team. Sometimes in the body of the email I want to include a link to a Smartsheet Item like a Dashboard or an external item like a separate reference document. I have not yet found a way to do this attractively - I end up having to send the big, long, ugly URL. Thoughts?
-
Format Date
Is possible to declare one custom date format for a column and another format for another column using smartsheets?
-
What happens to Workspace items, if existing owner is not with the company?
Hi, I have a quick question; although I do know about the System Admin capability that allows it to transfer the ownership of items to a new user via User Management option. But does it also transfer items which that user owned in a Workspace (not workspace but the items on it!)? If yes, then I am good :) If no, then what…
-
RYG Automation using IF/AND function
Hi, I am creating a project management sheet with RYG symbols to trcak our progress. I have a sheet with the projects, status and due dates. What I'm trying to achieve is for the RYG symbols to automate based on the status and deadlines. If status is either in progress or for review, and is 2 days before the due date,…
-
Left panel menu
I liked the tabs on top of the sheets. I could put them in whatever order works for me. I don't mind the "left panel menu" that we now have instead - but I DO NEED to put the list of sheets in the order that makes sense for me! Every time I need to open a different sheet, I have to scan up and down the list of 20 sheets,…
-
Invitation to View link prompts password creation for an established user
Hello, An invitation to view link that was sent to one of our users prompts a password creation screen in Smartsheet when clicked, even though they already have a Smartsheet account and a few shared reports. (Page reads "Let's get started - Set up your password". See attached) Subsequent attempts to log in to Smartsheet as…
-
Request Access Notification
I provision all projects for our PMO and each project is housed in a Workspace to control access, so, I am the 'owner' for each project in our organization... This setup worked for a time, but now that we're scaling up, I'm receiving access requests for projects almost hourly. Unfortunately, the way we have our project…
-
Conditional formatting
Hello All, I am facing one problem with Conditional formatting. I've chosen one format to be applied if specific team is selected (in this case MW). The problem is that in most cases text color is white as I want to, but in couple rows the formatting doesn't work properly as it changes cell color but doesn't change text…
