-
Cross Sheet Formula with One Criteria
Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. I need a formula that if "Fail" is selected from the drop down menu, the step's ID # will automatically pull into Sheet #2…
-
Calculate Average Time
Hi Team, I have one sheet that calculates the time duration that a tech is onsite per line, but what I need to do is in another sheet calculate the average time TOTAL for all entries. I'm having trouble figuring out how to accomplish this. Thanks in advance for everyone's assistance!
-
How I find the first column?
I have a range of columns with 14 milestones. If the milestone reached, then it will be delete and the cell is blank. Now I would know, in which column are the first date. As result I would need the column-name, with the first date or the number of column, counted from the first column of the range. Any ideas, which…
-
Input the date for a multi-select dropdown
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium. Now, I'm aware that…
-
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…