-
INDEX/MATCH function doesn't return exact match.
I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting from left to right, or top to bottom. "-1" should find the first value less than or equal to the…
-
Certification Exam
I took the certification exam back in January as an "early adopter" for my team. Some of the other members are now getting around to taking it and asked me about the practical component (part II) where you have to send off a file for review. I didn't do one of those. Is this something new or did I miss it and not finish (I…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Hierrarchy in web forms
I have data broken out by region (AMER, EMEA, & APAC), and there is budget information contained in each row. The region is a parent and the corresponding rows are children. This allows me to get a regional budget summary. Is there a way to maintain this hierarchy (parent/child relationship) when rows are created using web…
-
How to calcualate time difference
Hi Team, How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM Regards,
-
SUM of Only Parents in Budget Sheet
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
-
Cross-Sheet SUMIFS is returning #UNPARSEABLE
Hello, I'm having an issue with a cross sheet formula. I'm trying to build a budget tracking system in two parts. It involves a top sheet with a the sum of all expenses by category and an expense log that is a running list of expenses. I tested the following SUMIFS in the expense log and it works correctly.Where it is…
-
Active turn around times by status of a row
I was wondering if theres a way/formula to track the amount of time a line stays in a certain status. For example - If we are using a line to track the life cycle of a contract we would have a created date field and a contract status field. The status field would consist of fields like "Contract Review" "Legal Review" "On…
-
Apostrophe added on mass insert thru CDATA
Hello, We are currently using a third party tool CDATA to upload excel data to a smartsheet. When any numeric data is entered, an apostrophe is always added to the beginning of the string. Upon checking the logs, CDATA is not sending an apostrophe to Smartsheet. The only thing I can think of is Smartsheet is adding the…
-
Formula for Actual duration excluding duplication
Hi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous time ranges. Please see example: Start: 01/10/2019 End: 04/10/2019 = 4 working days…
