-
How to show most frequent status per unique groupings?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Sum if by Status, Value & Month..
Hi All, I have variables of the formula I want in other sheets but cannot get it to work when adding a third criteria. (Unparseable), have tried multiple connotations, reaching out for advice. Basically I want the sum value for all confirmed projects completing in any given month. bold font below works on it's own…
-
Justify Text - how to do this?
Hi - using the form to collect info and use that to generate an document in PDF. But their is not an option to justify text and its all left justified. I need it to be equal like in word doc. Suggestions?
-
Help!
Does anyone have any idea of what barcode font to use when wanting to use numbers, uppercase, and lowercase letters characters on excel. I've tried tons of fonts found online as well as extended fonts but nothing seems to work correctly. Thank You.
-
Simple CountIf
I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?
-
How to return a cell from another sheet when the criteria is within a text string in the source?
I'm trying to pull the notes from a Request sheet into the Review sheet, but I'm only getting results when the search criteria (Contract #) is the only contract in the cell in the Request sheet. Ex 1: Line 1 in the source, "123" in the Contract #, has "Urgent" in Notes; the current formula returns the correct notes into…
-
Using COUNTIFS to reference another sheet
I am using a count if formular to get a project count by status and incoming year. Not sure what I am doing wrong but here is my formular. Label@row references project status - in this case "Not Started". I get an output of zero but there are 10 projects with this status. =COUNTIFS({Project plan status}, Label@row,…
-
How to get specific data from a list on sheet with most recent or higher level of issue?
So, I have a raw data sheet that shows each time an employee receives a type of correction within the organization. I need to somehow extract both the most recent and highest level they currently have based on only certain policies, and I have no idea how to build any formula to pull this needed information, here is an…
-
Can I update a cell date in one sheet and have another sheet also update to the same date?
Hi, I'm very new to using Smartsheet. We have two different smartsheets with the same project in both. I'd like to update a date in the date column and have it automatically update in the other smartsheet. is there a way to do this? if so, could you please provide a step-by-step for a fellow new user? Cheers, thank you!
-
Index Match Formula help. Index Match of Health status of an activity into Sheet Summary
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health symbol. =INDEX(Health:Health, MATCH("Task A",…
