-
How are you using Smartsheet to help you homeschool during COVID-19 closures?
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times per day. We've been getting a ton of work done without ever changing out of our pjs!…
-
Reporting on who and how many times an individual has attended events
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all the data about who is attending our events is in multiple sheets. Using email…
-
Index Match help
I am trying to convert from Excel to Smartsheet without adding a ton of columns to make this work. I am not if Index/Match is the way to go OR VLOOKUP, etc. Again, the entries from the operators will vary therefore the low/high specs are used in previous columns that you helped me with. This is the excel version of ONE…
-
Building tasks in Smartsheet: How to sort by dates instead of parent groups
I'm in the throes of building my first sheet and have finished setting up the dependencies and key tasks I need for my project. Tasks are set up by parent/child groups, based on task type. Now I want to build out the rest of the year using similar tasks. At this point, I want to be able to manipulate the sheet to look at…
-
Is there a way to make a Spanish Form?
I have copied the forms to Spanish but the send copy to email is still in English. Is there a way to change that or a Spanish speaking version?
-
Help with Cross Sheet JOIN(COLLECT) formula
I've built a formula to complete a JOIN(COLLECT). If I put the formula on the same sheet as my column references it works just fine, however when I move this to a separate sheet and update the column references to the other sheet I get the error #UNPARSEABLE. From what I can tell I haven't removed any of the formula…
-
Validate Column Data Received in a Form
I have created a simple form to collect the following fields of data: First Name Last Name Email ID number Because a lot of times people are entering information into a form from a mobile device and sometimes have "fat fingers," I wanted to validate the ID column (with a list of users and IDs on another smartsheet). What…
-
Question on Counting days "If"
Hello, In my Smartsheet I have a status column that = "RESOLVED" or "IN PROGRESS" Each row has an "ENTRY" date and sometimes a "RESOLVED" date, if applicable. If a row is "IN PROGRESS" I want it to count the NETDAYS from today, but... If an row is marked "RESOLVED" I would like the NETDAYS function to stop counting.…
-
Nested IF Help
Hello, I have these columns: In a perfect world, when the status changes to RESOLVED, the date resolved would automatically populate. Since I can't do that without the use of something like Zapier, I'm trying to define a workaround using an additional column "Days to Resolve". Some issues have been resolved, but a…
-
Form Permissions?
I don't think this is possible, but I am asking anyway - if it's not possible I would like this added as an enhancement request... I'd like to see forms within sheets be able to be used by specific people only. The current options are basically anonymous (anyone with a link) or an authenticated user (could be anyone with a…