-
if and statement
Hi, I am currently facing a situation were one entity has multiple ID and country.Hence formula for region should be based on first Entity and then on Country..i think If AND formula has help like we do in excel. Can someone help me with an example how to perform it Thanks
-
Creating Dashboards
I am new to creating dashboards in SS. I have gone through the SS online tutorials and not finding the details I need. I need to create reports using formulas and what I have tried I have not been successful. Does anyone have suggestions on other materials to review?
-
return fiscal quarter from auto generated date column
Hi, this formula returns a blank - what is wrong? =IF(OR(MONTH([Created Date]9) = 8, MONTH([Created Date]9) = 9, MONTH([Created Date]9) = 10), "Q1FY " + YEAR([Created Date]9), IF(OR(MONTH([Created Date]9) = 11, MONTH([Created Date]9) = 12, MONTH([Created Date]9) = 1), "Q2FY " + YEAR([Created Date]9), IF(OR(MONTH([Created…
-
Index and Match
Hi , How to use Index and Match function in SS.Please advise with an example
-
WEEKNUMBER from two columns
Hi All, I have two columns where one column will have a DATE and the other one will be blank. It will never happen that both columns will have a date in them. Now I want Smartsheet to check which two cells has a Date and show WEEKNUMBER.
-
Need an HLOOKUP or similar
Does anyone have a formula that will evaluate all the cells in a row, then return the column name for the cell that has a particular value? Here's what I am trying to do. I have a Smartsheet with 23 columns, of which 5 are due dates. A 6th date column is "Next Due Date" and contains a formula that evaluate the other 5 date…
-
SUMIFS
I am trying to sum accounts receivable for individual salesmen. I have gotten to the point where I can add if the check box under [Check Received] is marked but I do not know how to sum if a check box is unmarked. So far my formula is returning 0 when it should be returning a over $100,000. This is my formula so…
-
COUNTIF Using Open-Ended Range Formula (Not Working)
I'm using the COUNTIF formula and am trying to set an open-ended range formula (see below). When I do so, I receive the error #UNPARSEABLE =COUNTIF(Test Result:Test Result, Status1) Is there any reason this wouldn't work? I've attached a screenshot of how Test Result is defined.
-
Transform time in minutes
Our Smartsheet has been build with time entered that way 2h00 0h15 0h15 1h00 3h00 2h00 1h00 0h15 0h15 3h00 0h30 18h00 I want to transform that value automatically in minutes (120 / 15 / 15 / 60 / 180 / 120 etc) Any idea on how to do it in smartsheet? thanks
-
% complete based on count of completed pieces
Hi, I'm running a project where I want to report our the % completion of a sub task based on the # of pieces completed. I'm thinking I need to create a formula as the % of completion functionality looks at duration vs. actual amount of work completed. Can someone offer guidance?
