-
Formulas
I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
-
Traffic lights count by colour if children
Hi there, I'm trying to count the number of projects according to their traffic light status across about 7 sheets. Given I want to display this in Sights as a Metric, I can't use a report so I have a sheet linking to the summary information from each sheet. When I use the Countif formula to count those that are "Red" it…
-
V Look Up
Hi I Am Trying to find out if i can do a Vlookup from another sheet ? Basicaly i have a sheet With items and Pricing from 3 Diferent Vendors I want on a diferent sheet have all my items in a srop down list and the Rate should Be looked up from the Prcing sheet in other Words i want to Quote it based on a price list sheet
-
Ranking Rows based on values in specific column
I would like to formulate a ranking system in a column that will base the rank on an existing column. Are there any functions that can do this?
-
Automatic Checkbox
Hello I am trying to get a checkbox to automatical put a checkmark in it when a certain status (done) is written but I cannot get it in the conditional formating. Also trying to get the rule the other way as well so that if checkbox is checked that status changes automatically to done but can't seem to find it in the…
-
Finding exact value with many criterions using joined index, match and sumifs functions
Hi, everyday I'm working with lot data, there is many of columns and even more of rows. And there is no specific function for finding text when several criteria should be used. For finding exact value we can use index and match function. For finding number we can use sumifs function with many of criteria. I had problem…
-
Sheet Column References in Equations
Is there a way to convert a column reference to a number like you can in excel? My problem is I'm to trying to input an equation that is a simple sum equation referenced to an input cell "x". Whatever number is put in for "x", will add to the column length that sum equation is good for, however when I try to do this, I get…
-
Formula Help - 2 columns and % Calculation
I am trying to give a percentage based on how 2 columns read. Column PassFailA and Column PassFailB. If both show Pass 100%, If A is Pass B is Fail or Vise Versa 50% and if both Fail 25% I think this will work, but will take any advice if there is a different way: =IF(AND([pass1]31 = "pass", [pass2]31 = "pass"), 1,…
-
Help with Complicated Formula IF(AND(OR involving % Complete and RYGG balls
Hello there! I'm a relatively new Smartsheet user and I've got an issue with a formula that I could really use your help with. Here's the formula: IF(AND(OR([Initial Draft Due or Task Start]12 < TODAY(), [Requested Edits Due]12 < TODAY(), [Revisions Due]12 < TODAY(), [Final Approval Due]12 < TODAY()), [% Complete]12 < 1),…