-
Replying to External Emails Workflow
Greetings, I was looking for a workflow that would allow us to reply to tickets from external accounts/emails that come in via the form from the 'IT Requests and Ticketing' template sheet. We'll be getting frequent back and forth correspondence and that external email should not have access to the entire sheet (only a…
-
Searching within a large dropdown list
Hello, I currently have an expense report for our company credit cards. On the expense report I have a drop down that lists all of the account numbers so that each line item can be posted to the correct account. There are hundreds of accounts and I would like to know if there is a way to broaden the search within the drop…
-
Using an OR in COLLECT
Hello - I'm trying to use an OR operator in the criteria of a collect function. This is currently returning an #INCORRECT ARGUMENT SET: =IFERROR(INDEX(COLLECT({WAP Deposit Number}, {WAP Date}, Date147, {WAP Type}, OR("CHECK", "CREDIT"), 1), "")) I'm trying to return the a deposit number {WAP Deposit Number} if the Date…
-
Can I link a Smartsheet dashboard to a sharepoint page? Please read the task below:
I am trying to link a Smartsheet dashboard to a Sharepoint page but this Smartsheet is edited twice a year and specific people need access to modify and then the rest of the business needs access to just view. How do I do this?
-
Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
-
Issues with Smartsheet and firewall
Because our company have access control on network, so we need to setup rules on our fortigate firewall to make user can access smartsheet. I try to following old post to setup our firewall, link is on the below: https://community.smartsheet.com/discussion/3509/issues-with-smartsheet-and-firewalls FQDN *.smartsheet.com…
-
index and match formula that works in some places and not others
Hi, I have an index and match formula that works in some places and not others. I tried to attach a screen show that shows what I am trying to do along with this description. My formula in the Time and Attendance row works as expected. The data for overall status, scope, timeline, resources and funding are matched and…
-
From Web Excel Query and Smartsheet Publish Link
Hello - This is a bit of an Excel/Smartsheet question in truth. We have some workflows that depend on the From Web data function in Excel (Data -> From Web). We have switched our publish link to only be accessible to people on our account (instead of being published publicly), and the workflow now fails. I believe this is…
-
CountIFs and Date range formula
Hi, need help with a formula. I am trying to count a type from one column 'Finding Rating' against a date range in another column 'Last Completed'. So far I have tried the following but they have all come up with UNPARSEABLE. FYI Conformance is one of the types that I need to count =COUNTIFS({Finding Rating}, =Conformance,…
-
Certified Smartsheet user on the look out
Hey friends, Anyone hiring experienced Smartsheet user, if so let me know! 😁 I've been using Smartsheet for 6 years, it's so much a part of my daily work productivity and I'd like to seek out another opportunity where I could transition my skills and background in program management into. I've gain so much knowledge and…
