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…
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/1…
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 …
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 statu…
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 3…
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 …
I have a [Due By] date column and a [Monday] checkbox column. I'm trying to create a formula that will check the box on any [Due By] that is a Monday. I got as far as getting the box to check if today…
You can now reference data from other sheets in formulas! Create a master lookup table sheet and use VLOOKUP to find data on another sheet. More information on this new feature is available in our hel…
Hello, I am new to using formulas and am struggling with trying to automatically check a checkbox in one column if, in the Risk column, the RYG risk is red or yellow, not checked if risk is Green. I a…
Hello, I'm having difficult trying to report on metrics that would outline the following: Identify the number of request types by project For example, if you have 5 projects, all named differently and…
