We're new user trying to understand how we can use daily schedule template to repeat itself on-going basis. When I go to settings it is grayed out so there goes that option. Spreadsheets are not something I've used too much and support is slow getting back to me
First of all, english is not my native langage, please excuse my mistakes. Hello all, I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able to reach / open it. I send requests for update with automatic processes. but when counterpart…
Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's the problem: If someone only "views" the sheet & doesn't make any updates, every single row in the…
I am looking for a way to filter on reports the same way you can filter on a sheet. It seems that on reports you can only sort whereas sheets allow you to filter. If this functionality is not available, I would like to request it be added to the future enhancements list. Thanks, Steve
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
A number of regions (countries) have very tight internet use. It would be helpful to be able to download local version, work on it while abroad and resync on return.
Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific processes.
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
Hi - I am trying to download the very first risk register template that is referenced on this page. https://www.smartsheet.com/risk-register-templates When I click the Smartsheet version, I get a completely different Risk Register. When I select Excel, I get the one pictured. I tried to download the Excel version and they…
Greetings - I'm having an issue trying to flag duplicates from 2 separate columns in the same sheet. I have been able to flag duplicates in a single stand-alone column but trying to using the same formula with the "COUNTIFS" function is leaving the flagged cell blank (as seen in row 2 of the screenshot attached). Here is…