-
How to add up new rows from forms into formulas?
Hi, I am a fairly new user and have created a form to calculate data from clients. I want to add up the data at the bottom of the form however, each time a new row is created, it isn't included in the sum, and using $ doesn't change that as row 1 becomes row 2 due to the latest form entry. Any way to fix that? Your help…
-
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…
-
Web content and google sheets - instructions don't work out
I've been trying to update a dashboard to include the new Web Content widget since I find managing some data and charts in Google Sheets far easier than in Smartsheet especially when collaborating on the data / file. I've followed along with the instructions for the Google chart I've created. Publish > Embed > and copy…
-
Send Update Request when there has been NO change to a cell
I have a project with multiple tasks assigned to different people. I want to automatically send recurring update requests (say every 7 days) if the "Progress" column has not been changed in those 7 days. It does not seem like smartsheet has the capability to do this. The trigger event for sending automatic update requests…
-
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?
-
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…
-
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…
-
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 %…
-
@ 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?
-
Sheet Name Appearing within Google Calendar Milestones
I understand that when publishing to Google Calendar the Smartsheet Name appears as the Calendar Name. My scenario is this: I have 5-10 projects going on at one time for one given client. So, if I am viewing all calendars at one time, the tasks/milestones are difficult to differentiate. Is there a work-around so that the…
