-
Merged: Processing Time and Cell/Row Limits
This discussion has been merged.
-
Data shuttle - compare entries between source file and target sheet
I need to compare entries from the source file to entries in the target sheet (form in the target sheet creates these entries). If the entry is in the source file then I want to leave that entry in the target sheet BUT if the entry in not in the source file, I want this entry to disappear from the target sheet and need to…
-
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…
-
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…
