-
Formula Issue
I want to get a dollar amount based on if a checkbox is selected. I am running a program where participants can get gift cards as incentives. I am using a separate sheet for the amount for each incentive. The other sheet columns are named the same as the incentive. Each column is a checkbox. To explain what I want, let me…
-
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
-
Smartsheet Gov JAWS (Screen Reader) Computability and Accessibility
In the current build of Smartsheet Gov, the highlighted cell in a sheet does not have the cell text / input connected to the name of the cell to be read by a screen reader. Three different screen reading software's were not successful in trying to read aloud the text in the highlighted / in focus cell. Having this issue…
-
Workflow not sending emails
I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set. Can anyone provide insight or suggestions?
-
From another sheet, how can i lookup / pull a list of values ?
Hello world, I have two data sheets that both have columns that contain a identifier for what the row references. I want to make a list in my third sheet that contains all the identifier values of these two data sheets that meet my criteria of containing letters xx in the end of their identifier names. Is this possible?…
-
External Communication
A way to communicate with external clients without letting them have access to the sheets (Without using proofing or having to create a dynamic view for every project).
-
Trying to Figure Out Scripts
Hey all! I must preface this by specifying that I am a complete newb when it comes to Smartsheet. I know the very absolutely basics, but am now trying to learn more about it. The issue I'm trying to figure out is keeping track of multiple packages I send out a week. I wanted to see if there's a way to write a script where…
-
Multiple Filters In Reports that Collaborators can Choose/Select
I want to be able to develop 1 master log and create reports and forms for employees to use to change or add data. In order to change filters, I believe you need more permissions than an editor. To follow through with my idea, the editors would need to be able to change the filters. What if we had the option to lock or…
-
how to combine multi formula conditions
Hi team, Trying to create a vehicle luggage capacity calculator for small and large cars, Please find below, Please find the below Formula: =IF(AND(Passengers@row <= 4, [25 Kg]@row <= 2, [15 Kg]@row <= 1, [7 Kg]@row <= 1), "Yes", "No") The formula above indicates the col [Result] is "Yes" in the ase of follows: The number…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
