-
Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
Sumif when the criterion is a date
I am not sure how to make the criterion when the cell has a date =SUMIF([Actual Payment Date]21:[Actual Payment Date]23, xxxxxxxx ,[Invoice Amount (tax incl.)]21:[Invoice Amount (tax incl.)]23) Thank you
-
Smartsheet Filter Won't Share
I clicked on Share filter on my worksheet, but my team members can't see it. Any troubleshooting ideas?
-
Check off category when all sub categories have been checked
Hello, I'm still new at Smartsheet so need a little bit of guidance. I think in this situation I need to use an IF formula and not conditional formatting. I want to add a rule that if all my sub-categories have been checked off, my category than be check off. Same rule would apply to a higher level, once all category have…
-
IF / THEN FORMULA HELP - Multiple Numerals
How do I create a if / then formula to show one response for multiple numeral answers such as IF Column1 is 1, 2 OR 3 then Column 2 is "acceptable" 4, 5, OR 7 then "tolerable" 6, 8, OR 9 then "undesirable" 10, 11 OR 12 then "intolerable
-
Plus or Minus based on text
I am currently setting up an inventory management sheet that has a webform. I want to be able to have data updated based on one column. What I have is a column that is Shipped / Received. When completing the form, if the user chooses Shipped, the QTY column displays -10 and then takes this away from total stock on hand. If…
-
Some of my parent rows are grey background, some are not...
Hi, I'm trying to figure out why some of my parent background are grey, and some are not. In the page: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows about 1/2 way down, under "Expanding and collapsing.." both "Administration" and "software engineers" parent rows are grey background. But in…
-
Using Hierarchy Formulas & Conditional Formatting to Color Code Rows in a Sheet
I’m always interested to hear if someone else has figured out a better way to do something, so feedback is welcome and appreciated! (: Example Sheet: Hierarchy Formulas & Conditional Formatting I like to use colors to help guide me through a sheet and I have settled on a process that works for me. *See Picture* Minimum…
-
IF Formula referencing one column to fill in another
Hi - I've been reading through the community posts and trying a variety of answers, but nothing I've tried seems to be working so I thought I'd post and ask for help. :) I am trying to establish a column that has an answer based on another cell. My columns: Dept Automation Lead So what I'm trying to create: IF Dept =…