Creating a Sum for Filtered Rows
I have a Sheet which contains a complete list of all invoices, which Customer they are for, the Invoice Total and an Invoice Paid column which would show the balance of the Invoice. I have created a number of Filters for all of my Customers, so that I can filter straight to one Customer and see their outstanding balance.…
How to force a sheet to fully recalculate via the API
Hi there API Developer community, I wish to use the API to force a sheet to recalculate. Currently, we use a report that shows just the first row of every one of our 50 or so project sheets and then we manually copy a new value into a column on that report that we have put aside for the purpose. So, once a value like…
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
How to stop due date reminders once task has been completed
HI- We use Smartsheet for tasks that need to be completed by several people. We currenlty have reminders set up for due dates (both 5 days before due date and past due date). Is there a way to NOT send the reminder if the task has been completed/the 'Date Completed' field has a date in it?
Edit Contact - Include Phone Number
Hi Community - I'm looking for a way to associate phone numbers with contacts (in addition to their email address). I would like the ability to hover over a contact's name (in an Assigned To column, for example) and see not only their email address, but also their phone number and perhaps additional information such as…
Does anyone have the formula syntax to control the RYG and Gray symbols on a sheet
Does anyone have the formula syntax for this.... to control the RYG and Gray symbols on a sheet? if due date < today and % complete <> 100% then red, if due date within 5 days of today and % complete <> 100% then yellow, if due date outside of 5 days from today % complete > 1 and < 100% then green, if % complete is 0 and…
When you link a row to another sheet will comments carry over? If not, is there a way to do this? Thank you, Crystal Lehto
Scheduled export of sheets
Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
Nested IF Statements
My nested IF statment =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 100, "Green", "Yellow")) is setting the symbol to "Yellow" when clearly the statment requires that IF([% Complete]3 = 100 (thie evaluates to true), "Green". What am I missing?
Dynamic drop down list
Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would update as sale demand changes. or being able to only select items of a certain type based off another column.