-
Countifs with Today Function
Hi! My team and I are having a hard time with some of our formulas. We need a count for how many projects that are ending in 30 days and as well as 90 days. Our currently formulas are not providing accurate numbers based off our what our filters are showing. Complete next 30 days formula: =COUNTIFS({HR Projects - Complete…
-
Dashboard/ Report "Current User" Not Updating
Seem to have an issue with the Dashboard I just created not updating appropriately. I have a report reading various project information from a sheet. With said report, I have the condition set to filter based on "Current User", which is reading the Project Manager Column (set to Contact List). The issue I'm seeing is if…
-
Return value if a cell in the same row has highest value in the column
I'm working on an email campaign and want to see which issue has the highest open rate. If a value in Column C has the highest value in the column, return the value of Column A in the same row. I'm stumped. Can anyone provide this formula? VLOOKUP seems like the obvious choice, but I don't know how to reference a MAX…
-
% Allocation Formula for Assigned To column
Hi @Genevieve P. Can you please help me come up with an IF formula to use in the % Allocation column for my sheet? This is what I am trying to formulate: If Bob (from the ‘Assigned To’ column) reaches greater than 100% allocation (from the sum of multiple rows), make the ‘Assigned To’ cell Fill in Red for wherever Bob’s…
-
Adding detailed information to a row / task
I have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do we intend to implement it? I.e., detailed info rather than simple notes etc. I can go to Card…
-
Creating a new smartsheet Project-type-sheet from scratch with the API
Hello. Trying to create a new Project-type-sheet with the API, and would like to designate everything about it the way I want in code, so NOT from a template. It appears there is no way to do this with the API, that it simply has no syntax for creating a gantt-enabled project sheet. Is this true? But next question - if you…
-
Using Countif in place of Autonumber - formatting question!
I'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request Type]@row, {Ticket Assignment}, 2, false) + (COUNTIFS([Request Type]$1:[Request…
-
Report with image of attachments
Hi Everyone, Is there a way to create a report that shows the image of the attachments? We have a quality control sheet that new items get added through a form along with a picture. I would like to create a report that can show the picture next to the fields associated the punch list item. Another way would be to export…
-
Rich Formatting On "Summary Sheet"
I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from multiple sheets and can be formatted. I have 20-30 real estate development/construction…
-
Cell Linking - Updating Source Sheet
Not sure if this has been answered before and if so, apologies, I could not find anything relevant. My team has been trying to link from a 'schedule' sheet out to smaller sheets so that we no longer have to manually update the smaller sheets. Unfortunately, we have found that whenever we need to update the linked cells in…
