-
How do I get my "IF" formula to automatically add to new rows?
We use zapier to add rows to the top of our primary active sheet from Pipeline. Within the active sheet are formulas set up for adding dollar amounts and hours. When a new row is added, these formulas carry "up" to the new row added in. However, I have an "IF" statement that will translate zip codes into cities (below).…
-
Listing text values from multiple rows in a single column, to a single cell
I am working on a master sheet for safety across our company. I have multiple rows (each specific to a particular project), of which there is a column for subcontractors who violate safety protocol (linked to a project-specific SS). Is there a particular way or formula that can be used to take all of the text from each…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Web Form Submissions Disappearing
Hello, I have a web form that I'm using to collect information, and it has been brought to my attention that a number of rows that were submitted by users, and for which they received confirmation emails, never showed up on the sheet. This poses a huge problem as each submission represents a request to process a payment,…
-
Auto populate worksheet through hyperlinks built with web forms
My objective right now is optimizing my worksheets to have as little human interaction as possible beyond entering inputs. To that end I have users input their data through web forms to populate my sheets. My issue is that I cannot generate hyperlinks automatically on the new rows created by the web-form. I have…
-
Does Smartsheet support SUM COUNTIFS formulas?
Howdy Smartsheet Community, I've written a =SUM(COUNTIFS) formula to count the number of specific text entries in one range that meet specific criteria. Based on the in-line formula help and online SUM COUNTIFS research I've done, it appears that my formula is correct but keeps returning #UNPARSEABLE. Has anyone…
-
Date Created System Column not updating if NOT using webform
I am modifying the "Help Desk Ticket Tracker & Form" template. I don't want to double-enter the date, so I deleted the 'date' column and am using the 'Created (date)' system-generated column. When I use the webform, it will fill in the date created. But if I add a line directly in the smartsheet, it leaves the Created date…
-
Column Copying
Hi, I have a need to add columns to all of my active project Smartsheets and then I need to create a webform on each of these sheets. Based on other posts I've seen, I cannot copy these columns from one Smartsheet to another so I need to manually add them, correct? Also, there is no way I can copy a webform from one sheet…
-
Colors in Workspaces
Hi, I have one set of custom colors for our entire site and a second set for a specific workspace. When I'm viewing a sheet that is in the workspace, all the tabs for currently open sheets turn that color, even if they aren't part of the workspace. When I'm viewing a sheet that is not in the workspace, all the tabs for…
-
Sights and Auto refresh rate
Hi, I have a client that wants to use Sights as a Dashboard on a Large Plasma in their office. They want the Dashboard to auto update/refresh without human intervention. Is there an Auto Refresh rate setting (Not seen one) I am looking at a Chrome extension called Super Auto Refresh. Has anybody got experience with this…