-
Vacation days formula; how to allow for half-days (or holidays)
Not having a lot of background experience with formulas, I am having difficulty determining whether or not the NETWORKDAYS formula can be "adjusted" to include an allowance for half-days. Using the Vacation template, it calculates the number from start to end days. I have added a check-box column for half-days. If this…
-
Expanding a line and losing any lines beneath it.
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
-
DATEONLY Formula Error Message
I cannot get my DATEONLY formula to work. It keeps giving me "missing or invalid parameters" as the result. I am trying to create a formula that gives me a date variance between Planned Start and Actual Start. My two column names are Planned Start and Start and I am trying to start in row 5. This is the formula I have and…
-
Rows Disappearing after having been moved from the origination page.
We have our sheet set up to where 1 sheet is used for order origination; the row is then moved to the sheet of the person who will be completing the task. The person will see it on their sheet and is able to change the status to accepted; however, in time, the row disappears all together. This is causing a lot of issues…
-
User Interface
I guess many of you are using Smartsheets to great effect in many different ways. Some of the ways I am configuring it for my clients is to act as a service request/ticketing tool (for cleaning/maintenance tasks). Customers fill in service request forms, which creates a new row in a sheet. There, a manager adds a bunch…
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
-
Push Merging - Is there a way to push a record form smartsheet to a Merge function
Hi All , Calling all Merge Experts - Google docs or another applicaiton. I am looking to build a quicker more accurate solution. I have a GDoc template created, I have a list of data that I merge from. Presently I have to go to the GDocs Document to then select 'add ons > smartsheet merge" to then Select the record I wish…
-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
160 character limit in field (used for sms)
Is is possible to set a l60 character limit to a field? The reason for this is that we collect texts from users (mostly by web form) that we will use for sms, but usually they write more than 160 characters which leads to extra work.
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
