-
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…
-
check box formula
Hello I am trying to do the following on my smartsheet. I have two columns : the first one with a checkbox format and the next column indicating the % completed. I want to create a condition such that, if the check box is ticked, the % complete indicates 100% else 0%(if not ticked). I used the following equation: IF(COL1 =…
-
Resource Management
Creating a Resource Management plan and hitting two snags: (1) Not all sheets are being accessed for the Resource plan butResource mgmt. is turned on in all sheets (2) Not all resources are being pulled from the worksheets. Unsure what "Users in your user account" means - how do I ensure all resources are being pulled into…
-
Card view - How to decide the "fastview" Columns?
Hi! When you go into card view and look at a card. You see the "Main collumn" as the card name but you also see 4 more columns without going into "edit". How do I decide what columns should be shown ON the card in card view? Kind Regards// Hugo Martinwall
