1) Creating a percentage to tally how much out of each section is checked completed. 2) Then also need to setup a formula to do the same for the overall sheet including all subheaders. This is the for…
I'm looking to have a health status (green, yellow, red) populate by checking multiple columns with differing expiration dates. I'm trying to come up with a formula that will return the following stat…
Hello I have an IF function I am trying to run that evaluates a cell, and then returns one of two indexing formula results I have verified that each indexing function and the If function itself with d…
Hi, I'm new to smartsheet and i would like to know how can i reference an entire column from another sheet, no criteria needed. I just want to return the data from sheet 1 column 1 to sheet 2 column 1…
Im having trouble figuring out a formula to create a flag in the overdue column when the due date is in the past and the status is pending or delayed. Flag needs to disapper once status changes to pai…
We are trying to move some of our more complex templates into Smartsheet but we're having trouble converting the concatenate with blank formulas from excel into smartsheet. For example we have this fo…
I have a Metrics sheet in which I'm trying to populate a dropdown list (multiple values) with building types from client portfolios. As an example Client A could have 5 buildings: 3 Office, 1 Industri…
I need help multiplying two columns. One is a formula equaling a percentage, the other is the value of another column that is adding multiple columns together. I keep getting in invalid value error. C…
Is there a way to hide cross sheet formula links? If you define a reference range on a sheet for vlookups I would rather not see all my columns on the parent sheet filled with little mouseover links. …
