-
GOOGLE FORM - ERROR
I had my Google form synced with Smartsheet and it has been working well. For no known reason, new form entries from Google no longer enter into Smartsheet. An error occurs when I go into the Google form and try to reconnect. The error is below: What could have caused this error? How can I fix this error without having to…
-
Drop down column based on previous response in web forms
I am looking at creating field in webform in such a way that, the number of columns are based on the response given earlier. For example, if 1st input asks for number of devices, I want that many number of columns to show up for taking in values for that many devices.
-
Making resource process with Smartsheet
Hi Ive got to admit that I am new to this concept. I need to figure out how to set up resourcing in my organization. It means that 12 teams who manage multiple project must also resource their work based on their team members allocation to that team. At any given time I need to see what projects are "draining" a portfolios…
-
Automating Harvey Balls based on RAG status
Hi, Could somoen please help with the formula I need to use to automate completion of Harvey Balls based on RAG status of four phases? I am using RAG status balls (Green, Yellow, Red and Blue) to indicate status of each phase of the implementation. I have four implementation phases and basically want the Harvey Balls to Go…
-
Setting start date for Calendar
Hi, I've just started using Smartsheet so hoping it will do all the things I need. My chart calendar starts in September 2014 even though all the things on my chart are from March 2015, how do I fix this, I don't want to have to move the bar along every time thanks Karen
-
Retrieve past reminders
Hi there, I use smartsheet for a lot of things incl. reminders for customer contact. I sometimes have a lot reminders in one day and the Email doesn't show them all but tells me that 'Additional reminders were set on xx more rows' Is there any way to change this so that it shows all the reminders in one Email or to…
-
Using a master list column and being able to link to other sheets
I have a question in regard to creating a dropdown list column. I want to be able to have a MASTER list that when I add a new item to the list that it will update to other sheets that contain the same list. Is this posible. I can see that I can copy and link rows to other sheets but it would appear that I cannot format a…
-
Hiding unrelated rows when using Search
Here's an idea from a user on twitter: jamiefeedback it'd be cool if the cmd+f search function hid unrelated rows, so as you type rows disappear from view -- this would let one compare values between several similar rows -- for example, rows containing "wedding" would be shown next to one another so you can compare the…
-
Sorting based on row color
Is it possible in Smartsheet to sort by color so that all rows in the same color comes after each other ?
-
How can I put a drop down menu that dynamically updates or adds another field?
How can I put a drop down menu that dynamically updates or adds another field? I am a Project Manager. In my Web Form I created a Project Name field that has a drop down list of current projects to choose from. After I select a project, I want another field to appear underneath it to give the end user another option to…