-
No Array formulas but need work around
Smartsheet does not use array formulas, but I need a way to list out items from one spreadsheet to another if a certain condition is met. For example, I have an array formula that I used in excel that would look for a certain condition on one spreadsheet then pull all the rows of data that had that condition to another…
-
Updating RYGB status based on date AND dropdown selection in multiple columns
Hello! I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns. So: Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple columns. Green is past due…
-
Cross sheet formula help
I have a master property sheet that is updated with new property information. One of the columns in the property information sheet is "Sales Rep." I created another sheet that I want to track the list of properties for each sales rep. 1 sheet is setup for each sales rep. I would like for the tracking sheet to pull all of…
-
Creating a 2nd date calculated from initial date
Added data in row with a created date I want to automate an expected close date 30 days from created date.However the expected close date could move and I want to be able to change that days adding on days until actual becomes yesterday. of this I want to run forcasting into months and length of sell cycle. I have read…
-
actual and forecast sales per month
I am trying to create a dashboard to show sales reveunues actual and projected. I have a column expected close date which I want to use for the forecast but the dates vary and although I can use month to get a numerical indicator of each month I cant work out how to create a formula which would capture all dates and…
-
Populate a drop down based on date in other columns
Is it possible to auto-populate a drop down based on a date being entered over a range of columns? Example: Column 1 (Drop Down) Pending (Date) Review (Date) Released (Date) Pending 2/21/19 Review 2/12/19 2/19/19 Released 2/12/19 2/19/19 2/21/19 So what I am looking for is if there is only a date in Pending, then Pending…
-
VLOOKUP/Matching/Collecting
Hi there, When a prospective customer fills out an online form and provides us with information, I want to be able to automatically match the specified services to one of our advisors from a separate database I have built. I understand VLOOKUP for one search value from one lookup table, but how can I specify multiple…
-
New Row Formula Issues/ Default New Row Feature?
I'm looking to take a Smartsheet I created for my department and to share it with other teams. It's fairly simple, but I have a few formulas doing some stuff: * A Status Ball that syncs with the status text. * A formula in a PARENT_PROJECT =(PARENT([Project]@row)) that syncs with the Parent Project name so that I can use…
-
Harvey Ball Formula
Needing a formula to turn Harvey Red, Yellow, and green. If sold box is checked = green. If Quote Submitted day is over 14 days, AND sold is NOT CHECKED = yellow. And if Quote submitted date is over 30 days past, AND SOLD is not checked = red. I have the green part correct =IF((Sold@row = 1, "Green"). Having trouble with…
-
Hyperlink to a server (referencing cells that tell it where on the server it is)
Good morning, When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside server and folder I'm working with. Excel does it perfectly, but I'm using SS to track things within a team. But it's 2…