-
Time Logger - Cell History
Is it possible to show time spent on a particular project? The data is already there within the cell history - it just need to be extracted somehow. The below data tells me the task has been "in progress" for 1 minute - 21.06 - 21.07
-
Secondary Formula in an OR Cell
Is it possible to have a sub formula be part of the main formula for an IF/OR cell? Basically what I am trying to do is write a formula that looks at Column A and if it is one of two answers from a drop down list report the percentage of the value of Column B, and if the value of Column A is a third value return 0. The…
-
Can you return a blank cell in a formula that isn't text?
Is it possible to return a blank cell which is then part of a formula that adds up with other cells to result in a monetary value? =IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the…
-
Formulas not following over
When I input a claim from the web form, it appears somewhat down in my sheet, and no formulas. This is also the case when I have a row with formulas, then I move it to another sheet with the same columns and formulas, but it appears in the subsequent sheet in the bottom row, but no formulas. This is very frustrating…
-
Feature Request: Rank order macro
We recently migrated from a google doc to smartsheet for tracking a project portfolio. Google docs offered the ability to apply a Rank Order macro to let us sort the list based on a calcuated priority score for each project in the list. Here is an example of the macro: =rank(AQ3,AQ:AQ) Smartsheets lets us score projects…
-
Money format in cell not working
I am using this formula to output a fee based on gross loss for insurance claim. The resulting total column shows proper dollar format when it is over $100,000 based on first IF statement. When it is either of the following IF statements, ie for losses > 500, or losses > than 0, then the "TOTAL" cell shows a dollar sign…
-
Active Reports
Has anyone out there been able to achieve this? What I would call an Active Report is as follows. A visually formatted report page that is interactive with a master sheet. The report sheet would be formatted to display a ascetically pleasing presentation of data select from the master sheet by selecting a row. This could…
-
Update Requests Limited?
I am sending update requests for a sheet that has initial items filled in by formulas - dates, as well as "Yes/No" dropdown selections. This makes it easy for the person who starts with this template to put in suggested initial dates, then ask for exact dates from these directly involved. In the sheet the editor can…
-
How can I conditionally update a cell but leave the current value there if the condition fails?
I keep track of about 40 active projects in our company. Among other things, I keep one Smartsheet on each project that shows the hours worked by several different functional areas on a week-by-week basis. I only want to put the current week's hours into the project history row for the current week after they have been…
-
Formula question
Hi Smartsheet community! I realize there is a help area for this but I have looked ... read.. googled.. till I'm blue. So this is new and I thought in this NEW COMMUNITY maybe I could shout out for some help. I am trying to do a formula so that the smartsheet can look at a month ( column ) and then determine in another (…
