-
SumIf and Contains referencing another sheet
Hi All, I have a sheet with a column of project codes and rows of individual's hours for each project. I want to build summary information on another sheet. So I want Smartsheet to sum the number of hours where the project code contains a unique set of 4 characters. I've gone through several of the community questions but…
-
COUNTIF AVERAGEIF
Hi, I’m trying to create a formula, that includes all that the Column Status contains “Current” & Column Rep. Name contains “Mike Bass” average on Column “Total Spent” I tried the below but didn’t work. =COUNTIF(Status:Status, ="Current", (AVERAGEIF([Rep. Name]:[Rep. Name], ="Mike Bass", [Total Spent]:[Total Spent]))) Pls…
-
Countifs formula to count a value within a date range?
Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that time frame. For example: I only want smartsheet to look at the surveys completed…
-
Text columns formatted from Excel Import
Hey there! Has anyone experienced a text/number column containing an apostrophe before the value upon the Excel import? And if yes, how do you correct this?
-
Suppress a dashboard widget if the underlying report has no rows
I have built a status report dashboard and would like to suppress a widget if the underlying report has no rows. For example: I have a report for issues where the PM needs help from someone (Help Needed checkbox). If there are no rows checked for the current reporting period, I'd like the report widget not to show up on…
-
IF, OR, Populate Statement
Hello everyone, not sure if this one is possible, but I'll give it a go. I want to create one formula that basically functions as below: IF([3MO Left Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Left Date]@row),IF([3MO Right Target Amputation]@row="Yes", Insert Date from [3MO Maj Amputation Right…
-
Displaying Actual Start/Actual Finish
Hi I have a chain of dependent tasks that all start on the same day, but because they are dependent, they waterfall out in the gantt. Is there a way to display the actual task start and finish dates in a column?
-
Update Request - View Only Fields
Is there way on an update request to include certain columns, but have them as view only, without locking the columns on the sheet? My Control Center creates project packages for my Project Managers. The PM's have Edit-Can Share rights to the created sheets (myself and an other person are owners and admins). This is done…
-
SUMIFS Formula Returning 0
Hi, I am doing a simple SUMIFS formula that is returning zero instead of the actual sum. Just for reference, the numbers in January's column are manually entered. The zero in February is where I am testing my formula. I have rearranged this formula so many times and it still returns zero instead of the $585. =SUMIFS([Grand…
-
Need help fixing this
=COUNTIFS({Behavior Based Safety Observation Range 4}, OR("no action need","complete", @cell)), {Behavior Based Safety Observation Range 2}, CONTAINS("STS - Operations (welding)", @cell)) First one i want it to count no action need or complete the second count welding department entries