-
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
RISK - Projects
Does anyone use Smartsheet for Risk Assessments / Risk Management? If so, What template do you use and what is your process? I've found on the link below several templates for Risk Management. However; when I download the excel and import it into smartsheet, the functionality is lost.…
-
Smartsheet as CRM with differentiated Accounts, Contacts, and Tasks
Hi everyone! I am trying to use Smartsheet as a simple but complete sales/CRM solution. I want to be able to have three different things: Accounts (like a company, "XYZ Tractors") Contacts (like a person, "John Smith, Senior Manager, employee at XYZ Tractors”) Tasks (“Create a sales quote for John”) In Smartsheet, there is…
-
Flag Trigger Formula
I am trying to create a formula to trigger a red flag based on two variables: a date column and a drop down task column. Here is the formula that I have created. What syntax do I use to look for an empty cell represented here with an "X"? =IF(AND([Contact Date]1 =TODAY, [Contact Results]1 = X)
-
Dashboard Color
Any plans in the future for letting us update the dashboard background color to any color we'd like? I'd love to be able to use black for dashboard backgrounds, as well as the backgrounds of the widgets, so that when on TV sets around the office, graphs are floating in black instead of a white background.
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
-
Upgrade not kicking in
Anyone know why an upgrade wouldn't kick in immediately? I've received a confirmation email from Smartsheet, and my card shows the charge -- yet my account is still frozen (two hours and a relaunch from a cleared browser later). Frankly, I'm also a little disturbed by the lack of response to my email so far (and the…
-
Cross-Sheet Formulas
Hi! I am trying to reference another sheet in a SUMIF. But I get "#UNPARSEABLE" I want to sum contribution $ in Column 2 if the vendor name is 9X. This info is in Sheet2. I am referencing it in Sheet1 Here is the formula : =SUMIF({VEND},"=9X",[{DSU}]) I have tried the formula =SUMIF({VEND},"9X",[{DSU}]) And…
-
Dynamic Future Date based on Condition
Hello, Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example: If Phase is "SOW Draft/Negotiations", add 60 days to the "Phase Modified Date" (60 days that will dynamically update everyday, so today will be…
