I'm using a Formula to calculate the pays past due from today. The current formula I'm using is =NETWORKDAYS([Due Date],TODAY()), but the results aren't coming out as I would have anticipated. 9/29/2021 returns 2 days past due 9/30/2021 returns 1 day past due 10/1/2021 returns -2 days past due So, I created a formula that…
Hello- My username is identified as a resource on "Other Sheets" in the Resource View - which I can't identify. Is there a way to see what those unlinked sheets are? I suspect it might be from a client's Smartsheet - is there a way to filter resource views by sheets within my own organization? Thanks! Amanda
I have been using the Automated send function to send emails to specific people on a specific date. I am wondering if there is a way to track if the email was opened from the backend of SmartSheets. Staff I work with say that the emails are delivering to some and not delivering to others (or at least they don't think…
This Community is awesome. Thanks for all the help you didn't know I got from here. This is a question whose answer I can't find. We recently created a Smartsheet for tracking procurement data. In testing, we've used 15 or so rows. It doesn't appear I can delete the rows and start from Row 1 and have the built-in…
I want to set notifications up for my staff that only occur during business hours. Monday - Friday at 8AM
I am not looking to use the activity log as I do not find it useful for actual visit tracking because it also tracks other things like changes I make to pages - and I am always updating things. I was looking at Zapier but no idea how to get started. Can anyone help? Cheers, Kristine
Hello. I have a report that is displaying 15-20 rows of data (will never exceed 25 rows). The problem is that the report appears to default to showing 50 rows regardless of the data. As a result, in the current state, there will always be between 25 to 35 blank rows on this report. I am looking to use this report on a…
I have two questions regarding contacts and automation... 1) When setting up an automated workflow, instead of entering for example 25 individual emails (sending to specific people), can you enter a distribution list? Many times we need automated workflows to go to be sent to a large group of individuals. Entering that…
Hi Expert, I did a data upload via data shuffle from an excel file including the following English dates e.g. Dec 1., Feb 1, April But in Smartsheet it looks like this: So it switch the month with the day. My settings are english in smartsheet as well. How can I fix it? Thanks
Hello friends, I'm attempting to create a new grid that links to sheet summary data in a few different spaces so my one grid autopopulates while the other sheet summaries change. Is this possible? Thanks!
I have a set list of statuses that I want to keep track of and collect durations. For example, when the status changes to Sent to Lab (Ongoing), I want it to record a date in the Sent to Lab column. I feel like it should be an easy thing to do I just can't get it right.
I am trying to have a sheet that reports multiple sheets. I have merged cells and that works but I am looking to merge a whole row of dates to a single cell with the most current date featured.
Our whole operation has ground to a halt as the cell limit of 500,000 has been hit. I reduced the number of columns such that the total amount of cells is now well under 500,000. Yet the sheet and form attached still remains inactive. How do I reactivate? Thanks for any assistance from the Smartsheet community. Rgds, Dave
Help shape the future of Smartsheet. Share your ideas and feature requests.