-
Web Forms
Hi, I wondered if anyone can help me with the following web form queries:- * Is there a way of showing, on the Smartsheet, the text you enter in the ‘Help Text’ field in the web form? * If you are awaiting responses from a certain number of people, how can you monitor which are still outstanding? * Can you prepopulate…
-
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)…
-
smartsheet outlook add-in (compatible with 64 bit office?)
Installing office on a new computer. The default install is the 32 bit version but the 64 bit version is supposed to allow access to more RAM for large excel & project files. Just wondering if the smartsheet outlook add-in works with the 64 bit version of outlook. I supposed I can install/uninstall if it doesn't but just…
-
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…
-
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…
-
moving multiple columns (awesome)
I don't know why I never tried this before but I aways move columns one at a time when arranging a sheet. Well I just stumbled into the fact that you can select a group of columns and move them together as a group (awesome!) Just sharing, ..... mike
-
Count total of RYG balls
Hi, can someone please help me - I am trying to count the total of Red, Yellow and Green Balls in a column and cant get my formula to work. Currently my formula reads =COUNTIFS([Status2]4:[Status2]33, "GREEN", "YELLOW", "RED") thank you
-
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
-
CHECK BOX
Hello. I have three columns that are dependent on one another. The first column contains the dropdown list: Received, Awaiting, Not Required. The second column consists of check boxes and the third column is % complete column. Is it possible to make the check box cell for a particular row blank/empty given the choice in…