-
Need Help, Nested If Date formula
I am trying to streamline a sheet that is used for project payment forecasting. The goal is to use the project's estimated ship date, when 40% of the project total is due, and have the 40% amount cell be copied into the corresponding date columns. I have a column for each month going to the end of the year. The sheet is a…
-
Set a recurring time to update cells linked from another sheet
I have 2 smartsheet items that I want to link together. On the master sheet, my colleagues update a column of cells with numeric values (CHILDREN) that totals to a (PARENT) cell. There are also some linked sheets that gets updated individually and then updated automatically on the master sheet in the same (PARENT) cell.…
-
Using more than symbol
Hi, i have a drop down that i use as below: One Country > One Country One Region > One Region Global my issue is that when i create a countifs statement - =COUNTIFS({9.Countries or Regions Impacted}, "> One Country") smartsheets adds anything together that starts "One....." so instead of counting just cells that have ">…
-
COUNTIFS function across sheets
Hi there, I am trying to count th: ree separate columns in my sheet. I tried the below in my sheet summary which gives me back 72 items, that I cross referenced by using filters in the sheet which looks correct =COUNTIFS([Is active]:[Is active], "Yes", Tier:Tier, "2", [Editable / Non Editable]:[Editable / Non Editable],…
-
Smartsheets issue with Start and End TIMES - is there a way to utilize MS project to feed that info?
Hi! I have been using Smartsheets for the past 4 years, and I love this product; however, one downfall is there is no ability to have an auto updated Start and End TIMES down to the minute (not dates) based on predecessor. On my past project, this was no big deal; however, on my new project, I have been asked to track down…
-
Auto Number Formular
We find the Smartsheet numbering system not very good as if a value is inputted accidentally and removed it wrecks the auto number and find you have to change from auto number to text/number and repair the auto number and reconfigure it. So I have been asked to create an auto number formular but with a catch. They one want…
-
How i find value from table depend on the value of row & column ?
Hi all , I have table : and i have value user will inter . how i can get value from table depend on the value of row & column ? and if value not existing , for ex ( 16.3 ) its not existing in header i need to go to closest value that mean 15 ?? Thanks
-
Using Index, Match, Min, If, and Today in one formula
Hi All, I'm new to Smartsheets but not new to Microsoft Excel and I'm struggling with trying to get this to work. Basically I'm trying to grab a text field after evaluating a date field. I got this to work using a basic index match. =INDEX([Summary]1:[Summary]13, MATCH(TODAY(), [Status Date]1:[Status Date]13, 0)) But this…
-
Why is my IF formula not producing the correct color circles?
Here is the formula I am using and every time I adjust it the formula always returns a red circle no matter what I change: =IF([Profit Margin]@row < "30.00%", "Red", IF(AND([Profit Margin]@row = "30.00%"), "Yellow", "Green")) I have also tried this formula: =IF([Profit Margin]@row < "30.00%", "Red", (IF(AND([Profit…
-
Index/Match vs. Index/Collect?
I am trying to collect multiple information sources into one collective sheet. First is the hours. Once I get the hang of the formula needed I can write for the others. Collection Sheet: The blank highlighted cell below is where I am trying to write the formula. I want the formula to return the facility hours from the…