-
Auto number
I created a sheet to track problems that arise on my project. I also created a form that my team can use to enter in those problems. On my sheet you can use the form or manually enter in the issue but for some reason the Auto number feature in my Issue ID column isn't calculating the issues entered correctly. The numbers…
-
Multiple answer sets in one drop down column?
Is there a way to have multiple answer sets in a column when building an assessment form? For example, if the answer to question 1 is either 'yes' or 'no', and the answer to question 2 is a choice from 'never', 'rarely', 'sometimes'... If the questions are listed in column 1, can column 2 be set up for multiple answer sets?
-
Sort by Sheet Summary fields in Row Report
Hello, I am curious whether there is a means by which I can use a Sheet Summary field to group and/or sort rows in a Row Report. For example, I want to give a group of sheets a "Priority" field (1, 2, 3, etc.) and then in a Row Report, be able to sort rows by the priority number associated with the sheet where the rows are…
-
Average IF formulae
Hi @Nick Korna, I have a scenario here where I have placed a simple Avg formulae and a AvgIF formulae to calculate scenario 1 But incase if there is a Zero, or NA or something, the formulae should be able to still calculate which isnt working with the simple IF or <>0 or If error. Can you please suggest.
-
IF and dates functions
If Cell B is a date in the future, I need Cell A to be blank. If Cell B has a date within 30 days, I need Cell A to say "CHECK". If Cell B has a date in the past, I need Cell A to say "Expired". However, If Cell C is checked, I need Cell A to say "No Need". If its not checked, Cell A is blank. However, If Cell D is…
-
I am trying to book an Orchestra using Smartsheet Forms and Sheets, any ideas?
The form needs to go out to the pool of musicians and poll their availability. Then the availability needs to be able to be quarriable to book musicians by part. For example, I need the following parts covered each day: Flue, Trumpet, Trombone, Tuba I need a form that can go out to all the flute platers and they select the…
-
Change values in drop down
I am trying to create a form for signing up volunteers for an event. The user selects the event name and date and then select the volunteer position (such as greeter, ushrer, emcee, etc.) and submit. What I would like to do is show only those positions that no one has signed up for yet. For example, first person see a list…
-
Vlookup with contacts
I'm probably missing something simple here but I can't see it. I'm using Vlookup to get information for contacts from one sheet to an other. Some of the names are getting a #nomatch error, and I have one returning the wrong value. Here are the sheets. I'm removing extra rows to keep it simple. Here is the formula…
-
" Save as New" is not working properly
Hi there İ would like to ask a question about aproblem that i have... i have an user and this user is licensed user.This user importing an excel file to smartsheet and then he is trying to save this sheet to a created workspace , with "save as new " button.Before he was able to see the folders ( under workspace that one…
-
How do I create a summary line in a schedule that shows the earliest start date and last end date?
I'm looking for a way to make the first row of a project schedule show the earliest start date and last end date without having to make all rows under #1 subordinate to row #1. This is just a pet peeve that in order to have one row in a schedule display the earliest start, total duration and last end date, I have to make…