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
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
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
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:…
Hello everyone, I'm beating my head against the wall at this point trying to figure out how to make this work. I have a project tracker - each row is an over view for a given project. In my case I have 8 columns for status that are all set to High, Medium, Low (cued RAG but not balls - conditional formatting for the color…
We use an AIA form process for the pay applications in our industry. I am wondering if anyone else has been able to implement an AIA form in a sheet?