Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for February 2017
Discussion List
Live Data Connector
I have a Smartsheet linked to Excel (using the Live Data Connector). When I refresh the data in Excel all data refreshes. Is there any way to limit what appears after refreshing? I only want to show what is new and/or what has been changed in Smartsheet?
Harvey Ball Average in a row
Hi All, is it possible to add a row of harvey balls and then get the average? If so could you share the formulas. thanks in advnce
Finding the latest date of certain tasks based of those tasks' attributes
Hello, I'm looking to find the latest end date for certain tasks based off of attributes in those tasks' rows. For example: If I want to find the latest date of tasks in cycle 1 of a release (but not cycle 2), and within that there are 5 different categories of tasks but I only want to know the latest end date of one of…
Is there a way to lock a column in a report?
Is there a way to lock a column in a report? My situation is that I have a Master sheet and then have a report where a user can enter data in one column but I don't want them to be able to change data in another column. If columns are locked on the Master then they have to be unlocked any time it needs updated by his team.…
20th of the following month formula
I have a situation where a sale rep gets paid commission 20th of the following month. I need a formula to look at the "Invoiced Date" say 16/02/17 and automatically enter 20/03/17 into the "Commission Date" . Then i need a cell (highlighted in blue in sheet) to calculate the commission when in rolls over into that…
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
How do I embed a web form into a WordPress site?
All I seem to get is a link to a form - not a form embedded into my site?
Scheduled Monthly report of previous month's activity
to all my formula gurus, Need some help thinking this through. I want to schedule a report that runs on the first of the month and pulls all data from a sheet where a "Closed Date" occured within the previous month. So on Feb 1, the report would pull all activity in the month of January where the "Date Closed" occurred…
Count Past Due and Coming Due Items
I would like to count past due and coming due items. For Past Due, I have a variance column that I have been able to use =COUNTIF(Variance2:Variance31, >0). The issue I have is that it is also counting completed tasks that had a variance but have since been checked off as done. Is there a way to haev it not include those?…
Want to return (blank cell) instead of $0.00 ???
=SUMIFS([Value of Jobs]2, [Sales Stage]2, "WON", Result2, 1, [Sold Date]2, MONTH(@cell) = MONTH(TODAY()), [Sold Date]2, YEAR(@cell) = YEAR(TODAY()))