-
Retrieving previous status to show on Dashboard
I have a Status Update worksheet. And what I'm trying to do is show the current update on a project dashboard and want to show the previous update to the dashboard as well. How can I automate this so it automatically will update my dashboard whenever I make updates to the Status Update worksheet?
-
Formula Help
Hello, I am trying to fix a formula that only partially works. Any help would be greatly appreciated. I have one column, labeled Account# with various drop-down options, multi-select. I have a second column labeled Multiple Accounts that is a checkbox column indicating when 2 or more accounts have been selected in the…
-
Need help with a formula
I am trying to calculate a percentage of items that meet a specified criteria during a particular period. I can calculate the percentage correctly [=COUNTIF(A:A>3)/COUNT(B:B)] but can't figure out how to add the filter for the period (it's a "Month" column). =IF(Month:Month=7(COUNTIF(A:A,">3")/(COUNT(B:B),"") does not work…
-
How do i use distinct with conditions please?
I have a column called nominators with multiple names and i want to do count distinct on this column but with a condition i want to filter the distinct by the year column as per below i thought the formula would be: =DISTINCT(IF({Colleague of the Month Range 3}=2023){Colleague of the Month Range 6})) but it's returning as…
-
Spreading contract value by Calendar Year based on Period of Performance start and end dates
Good evening, I am working on transitioning data from Excel to Smartsheets and am having trouble figuring out the Smartsheet equivalent to a formula I have used for years in Excel to spread contract value/revenue by calendar year as follows:…
-
Showing Continuous Trend even with Gap Data
For context, I am trying to show month by month trend, but there are some months where there are no data. Right now, my trend column (#3) compares the data(Column #1) in the current row to the row right below it. For rows where the row below has no data, is there a formula to get it to skip the empty row and compare it to…
-
Calculating a Dollar Amount from Percentage and Total # column
I am trying to create a formula row that looks at the total dollar amount of a budget ($100,000) and breaks it out into dollar amounts based on percentages in another column. For example: Percent Allocation column/row has 73% in it, and I have a field with a total budget number ($100,000). I want to populate another column…
-
How to remove the zero in a formula cell
I have a sheet that I'm inputting data in using a form, and then generating a document to print. Not all columns/cells will have an input on every instance, however, every cell is accounted for within the document mapping. The issue I'm running into is I have a column that has a column formula, and every time I have a new…
-
How to make Parent helper column reflect values based on Children values with multiple conditions
I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…
-
Formula to Pull Data from Source Sheet if Criteria Matches a Name
Background: I have a sheet with a list of users assigned to specific tasks; users may be assigned multiple tasks. The users are in a contact column, and I have created a column that contains only the names of the users. I'm trying to create individual sheets for each user that contain the tasks only assigned to them but…