-
Calculating sums using IF statements
I have two columns of data, one is a class of data in text, the other is a numerical value. I would like to calculate a subtotal of the value of the numerical value based on class. Is there an easy way to do this? I can pull a report based on the class, but it would be nice to have a running total of all classes and their…
-
Day of the week formulas
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
-
Drop Down Lists
I am new to smart sheets and way behind my fellow community members level. I have a database spreadsheet for tracking new product development. Question: can you incorporate a drop down list into a smartsheet. Appreciate your advice and apologies for the simplicity of the question. Reagrds, Mark Quillinan
-
Multiple projects and hour registration
Hi there, we are new to Smartsheet (testing) and would llike to registrate our EU projects. * - Registration of multiple projects * - Fill in the available budget * - hour registration from employees on these projects (different from budget) * - different hourly rate per project per person * - Tasks and deliverables within…
-
Formula To Ignore Zeros In Averages?
I have columns running left to right with the 12 months listed as the main header of each. I want to have a column on the far right that shows our average month's sales based on each months totals we go. RIght now it is May, but the simple AVG formula also counts June-December sicne they have zeros in them. So, instead of…
-
Alerts for Non shared users
Is there any way we can send alert or reminder to user which don't have authorization to sheet but email id appear in a contact list
-
today() function
I want to create a formula tht creates a Datestamp of when a checkbox is clicked. If I use the today() function the date will keep going up. Is there a way to lock a date to the day a checkbox is clicked? Thanks, Shaun
-
Web Forms using Hidden Fields with Formulas
I currently have a formula on a hidden field on a webform. When that web form is submitted, the formula is imported into the sheet with an apostrophe before the formula which creates an issue of having to manually adjust the formula after each web form submission. Can this be remedied? -Brenton
-
Preserve leading 0's:
-
Is there a way to use cell references in an IF() statement?
I know you can use cell references in the "logical_test" clause but is there a way to use them in the "value_if_true" and "value_if_false" clauses? Al the examples of IF() statements have just text strings for what the IF() statement resolves to. I'd like it to resolve to the value in another cell. For example:…
