-
Actual % Complete Formula?
I'm trying to answer some questions on why the Project % Complete values are what they are, in greater detail than what is provided in this help article (which just indicates that it is calculated by Smartsheet based on Duration and % complete of child rows). Does anyone know what the actual formula/process is that…
-
COUNTIFS formula with year
I'm trying to put together a COUNTIFS formula for my Sheet Summary that will count the number of items that are shown as Completed in the status column along with what year they were completed in. Looking at other discussions, I found this: =COUNTIFS([NVAP Phase/Status]:[NVAP Phase/Status], "Completed", [NVAP Completed…
-
Report Builder Problems
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-licensed) individuals who execute the tasks assigned. Am I correct in thinking that each…
-
Editing Chart Widget
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
-
URL for a Web Form
I have to publish the Web form link on SharePoint for internal staff to access, fill & submit their requests. If there are any changes in Web Form in future will original URL work? or it will change after changes done in the web form?
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Request update only if no recent update exists?
Am I being dense? I can see ways to automate a reminder based on conditions, but in a sheet with multiple submissions from one person, if I want to remind them ONLY if I haven’t received a recent update, I can’t say “don’t send if.” ? I can send a request for update based on “if not in the past” but if there is a recent…
-
SUMIF Formula - Incorrect Result?
Hello, I was looking over the SUMIF function yesterday on this page and noticed the incorrect result for the first row example. Am i wrong or should the correct result be $2303.00? FormulaDescriptionResult =SUMIF([Price Per Unit]1:[Price Per Unit]3, >20, [Transaction Total]1:[Transaction Total]3)Revenue Gained. SUM…
-
Formula to calculate the last update of a specific column
Hi. Is there a formula that will calculate the last time data in one specific column was updated? Thanks.
-
Automatically move item to different Smartsheet once completed?
I have a feeling that this solution doesn't exist within the current setup. Is it possible to move a row from one Smartsheet to another once the item is shown as completed? Thank you!