-
Import the summary into report format
Hi All, I have summary in my Grid file and i would like import to the report in rows not in the column? Any leads would be appreciated My example file below: Summary: Summary report: I can able to apply only in column and not in rows any suggestion? My wish is to bring like below: Please advise
-
How to implement default highlight color in to field name
Hello, At present Smartsheet providing highlight changes for recent updates. Is it possible to add a column/field to indicate the recent changes col name in that field.? For example I want to see all the recent changes for the past 2 days in the new column/field it will show this particular row Col-B and Col-D was updated…
-
Check box on Sheet if Name on one is same, and reviewer is the same.
I figured out the 2 separate functions. I am trying to check a box on Peer Review Master if the Employee to be Reviewed shows that a review has been submitted on the Peer Revie]w Submitted Sheet where the #1 Email from Peer REview Master matches the Reviewer Email from the Peer Reviews Submitted: From Peer Review Master:…
-
Nested CountIFS
Hello, I am stumped! I am trying to raise a flag when one cell is blank and 2 other cells match another row. In the example below, the first 2 rows should not be flagged because on is G8 and one is G9 in the Core Program column. The yellow rows should be flagged because none have a deletion date and the Core…
-
If/Then type formula
I have three percentages that are fed in a sheet summary. I can write this formula in the same sheet summary so there is no reason for cross sheet references. I need to write a formula that calculates the median of the three percentages. The only issue is that some of the percentages based upon the goals are beyond 100%.…
-
Employee Pulse Survey Template Set Formula Question
Hello I downloaded the template set for the employee pulse survey when I customized it, the formula to score the questions got erased. Does anyone have the the formula for the helper columns to assign a number next to the survey result? For example neutral should show 3 in the locked column. Thank you!
-
Increment numbers
Hi, We try to generate numbers via formula,,, everything works fine except auto increment,,, =IF(AND(Status@row <> "Forecast"; Status@row <> "Request"); IF(MAX(COLLECT([Help_Offers-/Project-Nr.]:[Help_Offers-/Project-Nr.]; [Help_Project-Nr._Generator]:[Help_Project-Nr._Generator]; =[Help_Project-Nr._Generator]@row)) = 0;…
-
Using Contact List as matching criteria for SumIF Formula
Dear Smartsheet Community ... I am stumped and exhausted my research efforts. We are not ready to implement resource management, users are not bought in but we do have to find a way to understand the teams balance. These individuals work on projects and have daily activities to tend to. The goal is to first understand the…
-
COUNTIFS formula help
Hello Smartsheet Community, I'm trying to get a COUNTIFS formula that tallies Column1 equals "CDB" Column2 is not blank Column 3 does not contain the word "Prime" OR "Early" I've got this part: =COUNTIFS(Column1:Column1, "CDB", Column2:Column2, <>"") But I can't figure out how to add the OR statement for Column 3 Any help…
-
Collecting Most recent Status (based on most recent date @ topic)
I wrote these, and I cannot seem to get them to work, can someone assist? To get status date - =MAX(COLLECT({Status Report - Status Date}, {Status Report - Workstream}, [primary column]@row)) to get the scope status for specific topic - =INDEX(COLLECT({Status Report - Scope}, {Status Report - Workstream}, [Primary…