-
What am i doing wrong
Need help with my formula why isnt it working?
-
Automating Day of the Week Lanes in Card view
Hi all, We're using Smartsheet to plan content development and scheduling for a radio station. We'd like to create lanes in the Card View for each day of the week (I already know how to do that part). But each row in grid view already has a broadcast date assigned to it, which of course feeds the Calendar view. I'd like to…
-
Formula to Count Data Broken Down by Month
I am wanting to use a formula to count data in various columns based on specific time period. Example for the month of October, I would like to count various column data and when it rolls into November I would like the formula to continue to work without changing it. I am able to use my formula (see below) to capture…
-
help with countIFS
I am using the following formula to count the total number of 100%'s in my range. it can count not blanks but doesnt count the total number of 100%'s. Can someone help me. what possibly is wrong in this formula? =COUNTIFS({Nexus Dependencies Range 5}, AND(NOT(ISBLANK(@cell)), @cell = 0.1), {Nexus Dependencies Range 1},…
-
Flag overlapping projects based on RYG ball
I've looked and am unsure if smartsheet is even capable of this, but can I turn on a flag based on if a new rows start date falls in between the start date and completion date of any other row? I'm also trying to have it triggered ONLY when the complexity (RYG ball) is red. Am I far off with this formula: =IF(AND([Start…
-
Flag by Last Modified Date Formula
Hi, I have a sheet for an event we are running and I want to flag any row that has been modified in the last 72 hours (3 days). Right now I have a flag column and a hidden modified date column. Any help with the formula please? Thank you! Jared
-
Formulas in Jira linked Sheets
Hi ! I'm trying to do the following: - I've created a Smartsheet that is linked to Jira. - to help me report on that, I want to add columns that are NOT mapped to Jira and to some calculation or add some information. After the first mapping, I can easily add these columns, but my issue is that every time a new Jira is…
-
Roundup causing error on reports
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. To make this worse any other formula on this sheet shows up as #blocked until this is removed
-
COUNT IF formula
Hello, I've read through a couple of different examples, but I am not having any luck. I am looking to have the # Assets count total displayed in the highlighted parent row/cell based on the following criteria. If # assets cell below the parent is greater than 0 for the total count to display.
-
Average of project completion for current year
I'm trying to average the "%" column based on rows that are only in quarter 1 (Quarter Identifier = 1), and have a completion date that is the current year. I'm trying to make this sheet roll over year-after-year and am trying to stay away from specifying "2019". The formula I have currently is: =AVG(COLLECT([%]:[%],…