-
Merged: "Send from" contacts in a cell or specific person enhancement
This discussion has been merged.
-
Form Options - Automation
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…
-
How can I get the sum of one column meeting two conditions
Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Manager, "John Smith", Invoice Date:Invoice Date, MONTH(@cell) = 1), [Billable Total]:[Billable Total])
-
Mass producing Dashboard with web content widgets
hello everyone, I created a dashboard to act as a huddle board for the business meetings and we will need about 100 different dashboards but dont want an update on one board to impact the other boards. We used web content widgets and when we "save as new" to make a copy - we are having to go in with the unique publishing…
-
how to set up automation logic for move row based on field value
Hello! I have a sheet populated by a form evaluating items identified by #'s. . There are several hundred items to be evaluated and users may fill out this form several times a year. My goal is to have the sheet showing only the most recent evaluation for each item. I would like to create an automation so that each…
-
Merged: Cross Sheet Hyperlinks
This discussion has been merged.
-
Formula Help
Hey guys, I need help to put a formula in my sheet that can sum all 'Type A' column that are from a specific campaign and specific market. for example all total of type A for Jazz (campaign) AT (market) I thought it would be something like, but neither are working =SUMIFS(Campaign:Campaign, "Jazz", Market:Market, "AT",…
-
Is there a way to pull a report or log for Automation Workflows?
I Have an Automatic workflow where once a new line is inserted it emails a contact but it didn't send 1 night and wanted to see if there's audit that it didn't run or if there was an error of some sort. thanks, Sean
-
Hyperlink URL and Display Text from two separate fields?
I have a Form entry that is asking for a (human readable) tag name in one field, and a hyperlink URL (non-smartsheet location) in another. I want to populate a single Smartsheet cell with the hyperlink pointing to the URL, but with the Display Text of the human readable tag... and I can't figure out how to make this…
-
Fillable text box isnt show all the information?
Hello, I am having trouble with the fillable text boxes and i dont know what is wrong. I current have the sheet set up so they fill the form out and whats not working is the commas and last number of the salary wont show up on the final PDF. See below for more detail: So I am just wondering if I need a helper column to…