- Index / Match Multiple columns from another sheet
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the team information. When I add a name to the new sheet, I assign that name to a team.…
- How to handle a very long list of (multiple select) choices in a form
I am new to Smartsheet and using it to replace old InfoPath forms. One thing I cannot find an elegant solution for is expanding fields/sections. Basically, I want to send an instructor a form that asks which courses they would like to teach next semester. There are hundreds of courses. I will eventually want to use this to…
- Validate if the Hyperlinks in the cell are a valid URL's
Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. Thanks
- Smartsheet calendar fail to sync with Google Calendar
Hi Community, I'm a smartsheet beginner and hoping I can get some help here. When I follow the steps to publish a smartsheet calendar to Google calendar, the process seems smooth without any trouble. But somehow when I check my google calendar, there is just nothing. The smartsheet calendar didn't appear on the Google…
- Automating RYG balls to change colors
So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have a green ball, I want the ball for the parent to be green If all dependencies have a…
- Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…
- Arabic Language
hi we would like this platform to support Arabic Language as a GUI thanks
- Error issue when trying to sync Google Forms
Hi, I just created a new form in google forms and when I try to sync with smartsheet I get this error: Error: Start Send (create sheet): Exception: No item with the given ID could be found, or you do not have permission to access it. Both google account and smartsheet are the same email address. I was able to sync a…
- Auto-Lock All the Child Rows
嗨,我知道如何锁当一行certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanism. Thanks in advance! Nasir
- Variance Netdays
Hello everyone, I read some of the threads about this issue, but cannot find the right answer. Members of my team are consultants and work primarily on weekends so I am using the NETDAY function to calculate the variance. If I use the formula as is, meeting the deadline will give a "1" instead of 0. To avoid this I added a…
