-
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…
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?
-
Countif in Progress and late
Dear, I am trying to reference from another sheet (Cloud), tasks that are in progress or not started but late. I tried adapting the below formulas but none is working. Can anyone help me please =COUNTIF({Cloud Range 1}, "In Progress", "Not Started), [Due Date:Due Date], <Today()) =COUNTIFS({Cloud Range 1}, Status:Status,…
-
Building sheets that talk to each other
Hello, I have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work. I basically want one sheet that our shipping team updates to automatically update another sheet my purchasing team uses. The columns have dates and check boxes so when…
-
Receipt for Work Completed
I want to auto generate a receipt with Zapier or something and send it to the supervisor and client upon work completed. Problem: Our electricians perform tests on all equipment we install. We have many QC forms that we use but using them is very cumbersome. Our techs need to ensure that they print them off before going to…