-
Formula to flag red with multiple criteria
Hi. My name is Frank. I have been working on this formula for quite a while now including requests to Smartsheet support. The formula is to raise a red flag when the end date is less than 3 days away with specific status options. I finally got it working the way I want with 1 exception. It does not automatically account…
-
Workflow or Alarm
Hello all, I work in company established in Germany. So my english writing can confuse you. I am new here and want to ask a question regarding the workflow / alarm tool. The automated mails are linked to a formular or the receiver gets a link to the complete Project. Is it possible to link the alarm to a DashBoard? This is…
-
What happens when I reach my 5000th row?
May I know if there will be any alert when a sheet is reaching it's 5000th row? My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity? Thanks.
-
Can a Dependency outcome be set to show an early or late value in production process?
Hi There, I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to see where the delays are happening in the process and analyse where to improve. I have set the dependency between the…
-
Sheet Summary Limit
Is there a hard limit to the number of fields we can add into the new Sheet Summary page?
-
Team Calendar on MS Teams
Hi. My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view? Thanks, Martha
-
Automating a way of understanding time difference when start and end time are in the same column.
Hi everyone, We are looking at using a smartsheet solution to understand how much time employees on our production lines are spending working on certain lines. I created a separate sheet for each production line (we have 12 production lines) and I am using QR codes scanned via a smartsheet form (Quick for employees to…
-
Auto Refresh Data?
I have developed a web form for a sheet I am using to collect production data from our production lines. I am then using a smartsheet sights to display production data on a dashboard I have published. I may be wrong, but I think the sheet that the data is being sent to needs to be manually refreshed so that the sight will…
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…