-
@ mentions not working
I am not receiving @ mention in comments even though my Notifications>Personal Settings are all checked. Other users are receiving them fine. My email appears in the dropdown as sheet collaborator. I am the owner of all the sheets. Anybody have any ideas?
-
IF, AND, OR (all 3) (formula) Help
Hello! I am trying to create a formula to count if any kind of combination of the below is met: =IF(AND([WU Enrollment Complete]:[WU Enrollment Complete], 1, [WU Pending]:[WU Pending], 1, ([Email 1]:[Email 1], 1, [Call 1]:[Call 1], 1, [Call 2]:[Call 2], 1, [Assigned to]:[Assigned to], "MyLe Nguyen") 1,0) It seems like the…
-
Create Splash Page (printable) for each Line Item
Hello, I want the ability to create a printable page that pulls from each column data, with each row constituting a new page. Any ideas on how to achieve this? It's like the opposite of a Report. Cheers,
-
One column is not populating from my form
I have a pretty straightforward form set up but one field (one column) is not populating into my sheet for some reason. It's a contact field with dropdown options. It shows the dropdown and lets me select values, but when I submit, they don't show up in the sheet, although all the other columns do. I've tried deleting and…
-
Automate update requests for every week if status is not 100%
Hi All, Is it possible to set up automated update requests until such time that the particular task is complete? What i am trying to achieve is: I have a large project involving 360 sites, i have created a sheet with 360 rows and 8 columns of status for different tasks. When a column is complete it adds 12.5% to the %…
-
Best way to layout sheet for multiple user data entry and charting
New to the program so am looking for some guidance to head down the right path. Lets say I have 10 different metrics that need to be updated once a week for 52 weeks. Each metric is owned by a different employee. I want them to enter their data, not send to me to enter. At the end of the day I need to be able to print one…
-
Conditional Formatting one row at a time
Hello, when I set up conditional formatting on a sheet it applies to the entire sheet. I would like to set a different criteria for each row and when the conditions are met, I would like that row to turn red. How can this be achieved?
-
WorkFlow with a Report Form
I have reporting into a Register working just fine now. Now I need to send out another report based on an item that has occurred within the main register. i.e. A New Hazard has been reported. The report populates the main register but some items need to be worked on and this is typically carried out by a manager. Their…
-
Calendar App: why can't I see settings?
First let me say that we're new to the Smartsheet Calendar App. I started the Calendar worksheet but my manager wanted a chance to set-up the Calendar App this time around ('cause it's fun). Even though I'm the owner on the worksheet (she's the Admin - see attached screen shot), I cannot edit the settings in Calendar App…
-
Why are my sheets suddenly view only when I try to use them on an iPad?
We have launched our Smartsheets system after months of designing and testing. We have been using iPads with the Smartsheet app during the entire process to do simple field updates. Now, the day that we launched, everyone is suddenly view only when using the Smartsheet app on the iPad, but when we log onto a computer, we…
