-
Formula Error
Hi, I can't seem to know where the error on the formula is. Or am I just using the wrong one. What I would like is that if there is not date on the Actual Completion Date, for it to be 0. If there is a Date, to enter the month number. =IF(NOT(ISBLANK([Actual Completion Date]@row), "", IF(ISBLANK([Actual Completion Date],…
-
INDEX/MATCH Function Trouble
Hi Community, I am not the best with formulas and having trouble. I have a Master Data sheet that has all my information about what each chemistry needs to be tested. I have my new sheet, where I want to be able to enter in my chemistry, then the sheet will pull information from the Master Sheet and fill it in, according…
-
Due date based on weekdays
I can't figure out how to create a formula that shows a due date based on 7 workdays vs. 7 days. I've tried everything I can find online, but it always shows up as invalid.
-
Formula for using priority symbols
Hi! I want to create a formula where I can count the children under each header in my Task Name column I have in my project plan. Each child in column Task Name has a high, medium, and low priority symbol (the down blue arrow, yellow dash, and red exclamation point) in a column called Priority. I want the header to…
-
Need Resource Deficiency Formula corrected
Hi there, Im wanting to track resource deficiency on my projects. I'm using Capacity planning templates for smartsheet and the deficiency formula is not giving me a correct formulation. Given that Total project Demand (HRS) = Sum of all hours per week from Level of Effort column Utilization Rate is Level of effort…
-
2 Part Question on Averages & Calculations in Reports
Hi folks, 2 part question: here is that when looking at individual rows in a Report, the calculations are correct for representing % difference between two #'s as seen below (difference between A and B = C). For example in the green boxed check-marked area you can see that the calculations make sense as would all of the…
-
LOOKUP with 3 criteria in different sheets
I have a "template A" where we collect all the PO numbers by different Country, Vendor name and Payer. In "template B" I want to create an automatic search function for the corresponding PO according to information in the 3 cells of the columns Payer, Country and Vendor. I understand that it would be the equivalent to…
-
Creating sheet for only assigned individual based on master sheet
Hello, I have a sheet which contains a combined view of Account Name and their assigned Accountant. The sheet has multiple rows and each Accountant can show up multiple times assigned to different clients. What is the best formula to use so that I can create individual data sheets for each Accountant that will only pull…
-
Auto populate a contact cell but still with overwrite capabilities
Hello, I am trying to "suggest" a contact in a contact list column but can't find a way to automatically populate a cell while still having the ability to overwrite it later if that suggestion is not correct. So I've got a Program column, a Suggested column, and a Assignee column. Program is a dropdown and Suggested…
-
Grouping on Reports - Source Column is Dropdown List with Multiple Values allowed
I am creating a Report where once I apply my filtering, I need to be able to Group my results based on specific criteria. One of those criteria comes from a source column in a sheet where the column is a Dropdown List that is allowed to have multiple values selected. When I create the Report, the column with the…