-
Linked Cells and Indentation
I'm pretty new to Smartsheet so please forgive any ignorance I may have. I have a program with three providers managing their portion of the program. I want to have each provider maintain their own schedule in their own sheet and have a master sheet that includes all the tasks that I'm managing as well as links to all the…
-
Changed Duration Time for Report
Hi, I just updated a couple of my sheets and changed the duration time to "0" to reflect a milestone. When I run my milestone report these changes are not updated. Is there a delay for some reason. I thought that updates once saved would be immediately reflected. -Laura
-
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…
-
Automated Approval Requests
HI , I Have set up an Approval Request Which works amazing My only Issue is that my client that needs to approve the job Request Gets in his email for each Request line an email but its an auto Reply to the Previous Request Is there a way by the delivery settings to set that the subject of the email should always Reference…
-
Date fields not working on Live Data Link API
This is day two of the date fields coming into our excel sheet as 01/01/1900 and it causing problems with our scheduling needs. What is the ETA of this getting resolved?
-
Want to track resource allocation
Has anyone had any luck with this? Want to do something similar to the features in Microsoft Project. I have a lot of design projects going on and want to be able to allocate resources (my designers) to projects and be alerted to when a resource is exhausted. Has anyone been able to figure this out? I would really…
-
Risk Level Formula
Hello, I am trying to calculate risk level automatically (by displaying RYG balls) based on the following: Risk Level is Green If I get one of the following combinations: * Impact = Low AND Probability = Not Likely * Impact = Low AND Probability = Likely * Impact = Med AND Probability = Not Likely Risk Level is Yellow If I…
-
Simple way for creating dashboard on issue log
So I am logging issues on a sheet and there is a column showing the respective status (i.e. Open, WIP, Closed, etc.) for each of them. I m in search of a simple way to create a dashboard to show the no. of issues under each status on the same sheet.
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
-
Combine formulas referencing the same cell without running into a circle reference
Is it possible to combine multiple formulas referencing the same cell without running into a circle reference? Similar to passing an object to a function. I would like to combine the 3 formulas below for efficiency sake rather than creating additional columns. =SUM([column name]24/ 1000) =ROUND([column name]24, 1) ="$" +…
