-
Capture Issues for the Past Month - Formula required.
Hi Can someone please help me again :-( I am trying to capture the number of issues per brand over the past Month. For example for Queensland I have the below formula working (Number of issues in total) =COUNTIF({Dev Drafting Help: Brand}, [Primary Column]17) I tried to capture for the past month (unsuccessful)…
-
stopping messages
Hi all, I'm new to this Forum. Does anyone know if there is a way to stop a message send out of smart sheet. I know how to cancel an update request but cannot find how to stop a message send that is still in the queue thanks
-
Displaying formula sub-components values (Like F9 in Excel)
Hi all, When having a long formula in Excel, I know I can highlight a part of the formula, press F9. The value of the subpart is then returned. Is there some way to do something similar in Smartsheet ? Best,
-
Web form entries auto-populated one row below rows containing formulas
Hi, I've created Request management tool, which seems to be working fine. The issue I'm facing, is that when user fills out web form and new ticket is created, entries are not being auto-populated into the rows containing formulas, but one row below instead (which is formula free). How I can fix this? Thank you, Edvin
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…
-
Weekends
To enter WEEKENDS as typical non-working days, and as to not have them counted in schedule durations, we simply go into EDIT PROJECT SETTINGS and make sure Saturday/Sunday are not checked. This is great throughout the duration of the project. But what do you do when you need to have a crew work through a specific weekend…
-
Referencing other sheets
Hello, I have a sheet where I want to add totals in 7 other sheets for January - December for several drugs. When I get to February, it tells me I am at the max for references. I think it was 15. We have 7 squads...each squad seizes many drugs per month. I am trying to get the grand total of the drugs for all 7 squads for…
-
Crosssheet Countifs using Date and OR
Counting data from another sheet: Need instances of Class , if, Date is >= Start date, Date is <= End date, Class needs to ="Webinar: AGM", "Webinar: Hybrid", "Webinar: ToolBox", or Webinar: Objections" Columns = {Class} and {Date2} Cell References= [Start Date]1 and [End Date]1 Formula says invalid operation.…
-
RYGB Formula
I'm trying to get a RYGB formula to work. I'm thinking my order is wrong but I'm not sure. I had it working for RYGG but was asked to show Completed Tasks in a different color. I would like to change this so that Blue = Complete and N/A and Not Started are blank. Formula that is currently working for RYGG: =IF(Status@row =…
-
Scheduled but not done formula
I have a data set that has a Schedule Date (attached screen shot of data), and there is a column that has a check box that is referencing that field. I send the Smartsjeet form to a user, and they put a check mark in the check box if they have completed. If that box is not checked, and the date is later than today, I would…
