-
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…
-
How to track time on a weekly basis without Resource Management?
I created a sheet to keep track of Resource's time on a weekly basis. I'm trying to find out if there I can create a metric sheet or summary report to calculate per week to give me a total of hours per month.
-
Why can't I add chart data?
I want to make a chart, however, I can't seem to add any valid data into dashboard. The referenced data is greyed out (see picture) and if I press OK, then a red text comes up saying; "Selected data cannot be charted. Please select a new range". How do I solve this issue?