-
Tracking actual time in percentages, reporting in hours?
A component is adamant about tracking their actual time on projects based on percentage of an 8-hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way for staff to enter a percentage and convert that to hours for reporting purposes?
-
Using IFERROR to reference 2 sheets
Using the formula below to pull references from two sheets. I am getting data returned from the first sheet, but not the second. When I reverse the order of the references the formula works the other way around. Do I have an extra bracket or something causing it not to index past the first sheet? =IFERROR(INDEX({Milestone…
-
Combining Formulas - Average, Collect, Combine, Value, IF Error
Hello, I need help with a formula combing average, value, collect, and contains. I am trying to pull data from another sheet pulling out just the values from the selected options (options are 4 - Complete Success, 3 - Success with Minor Risk, 2 - Success with Major Risk and 1 - Process Breakdown) and then to average them…
-
Subtraction Formula
Hi folks, I have a Debt total in a cell on my budget spreadsheet (e.g. 7000); I have a row of payments by month (e.g. 160). I want to subtract each new cell of payment of 160 from the total cell of 7000. I want to visibly see the reduction on the 7000 debt cell when each new month of payment is added. Is there a formula…
-
Need help - adding less than or equal value to a current formula
Hello, Currently I'm struggling to add <= value to my current formula code, my idea is to count for Order Numbers (Unique values) and Lines of Order Numbers of certain times. since filter doesn't work in this code, I'd like to add a <= or >= value formula for Ship_Time, so my code filters can automatically generate…
-
Cross-sheet References - New Unknown Statuses
Hi all We are experiencing strange behavior of cross-sheet references with status showing something we haven't seen before and doesn't appear to be documented: 'Not Shared' or 'Circular'. Also - recently many of cross-sheet reference have become Broken (randomly across all sheets we are using). Is anyone experiencing…
-
Combining SUM and RIGHT
Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me? A1, Customer…
-
VLOOKUP with multiple reference sheets
Good afternoon! I attempted to use this template to create a multiple cross-sheet reference VLOOKUP. It works for the first three sheets but everything after the first three makes the formula unparseable. Any chance I can get some help? I have a handful more to add after this (a total of 36 sheets) but I wanted to try and…
-
=IFERROR(INDEX(DISTINCT) returning #UNPARSEABLE
Hi Smartsheet Community I have a rather complicated set up with this one. I have a source sheet with the following columns: [Full Name], [Month, KES Number], [Classroom], and a helper column ([Month]+[KES Number]+[Classroom]). I'm using the helper column to identify unique instances. On the target sheet, I have: [Full…
-
formula help
Hello I have a check box to auto check to indicate next month however; I've run into an issue with January not checking and I believe it has to do with it being a new year. I found a formula that someone needed to look back from January to December and i tried to make it work for next month but it's not working. How can I…
