How can a test be run on a text value to see if it matches?
Hi, has anyone had any luck using an exact match formula is Smartsheet? I have two columns that have text in them. I want the 3rd column to tell me if column 1 and 2 are an exact match or not. I know how to do it in excel =Exact(A1:B1) but not sure how to set up in Smartsheet. Also, can you apply a formula to an entire…
For expenses sheets it would be very useful to lookup fx rates based on the expense date for calculating local currency to reference currency amounts easily. Thanks
Hello, Is it possible to have a summary row at the top of my sheet that is "locked" sort of. Meaning, when i filter on certain criteria, the summary row will only total that criteria.??
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…
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
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
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…
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…
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
