-
Pull date from text string for conditional formatting
I have a text string column that always ends with "by [date]" on a sheet that someone else manages. They want to keep the text in that paragraph instead of using a separate date column, but they want conditional formatting on the date column… I have a formula that pulls the text value from the Next Deliverable(s) column:…
-
Multiple criteria for Index/Match (or collect?)
Hello, I am trying to return data from a cell in a reference sheet based on (2) criteria - one at the row, and one in the 1st row of that column. I have metrics sheets that accomplish a similar function but those are using sumif for calculations, whereas here I just need to pull in text. How do I create an index/match or…
-
Recurring Tasks - Please.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.…
-
How do you add a recurring monthly task to a sheet?
We have a task tracking sheet where tasks are added after being entered into a form. Some tasks occur on a monthly basis, and we'd like to find a way to have them automatically added to the sheet rather than having to enter the details every month. Is there a way to do this? I've found similar questions where the answer…
-
Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not Started once a recurring task is marked Complete. I need to be able to do this at the…
-
How can I pull reports data from Resource Management connect to Power BI?
I'm not a developer and my knowledge of APIs are limited. I'm working on getting data from the resource management tool to power bi. I was able to pull all data, except for reports. I know I have to do a POST request, which I'm trying for the first time. I did run this query and I'm still getting errors. I'm getting this…
-
ERROR ESPACIO DE TRABAJO
NO PUEDO ACCEDER A MI ESPACIO DE TRABAJO ME MARCA ERROR
-
Is aws.relay.smartsheet.com the set of IP addresses that any Smartsheet connections will come from
Specifically I have a client whose security team have forced IP based allow listing on their Salesforce instance, which has of course broken the Smartsheet→Salesforce connector I setup for them. So, are the IPs returned by the aws.relay.smartsheet.com DNS A record the valid list for connections to Salesforce from…
-
CEO
How do I update my users on smart sheet? I downloaded my smartsheet user reports and there is old employees I have to delete?
-
Feature Request: Bulk Creation of Asset Automations via CSV Upload
Hello, As a recent user I was tasked with creating a large number of Asset Automations (100+) having already created a spreadsheet to track the task and required fields I thought it would be beneficial to all users if this processes could be automated via CSV upload. Why This Matters: Currently, Asset Automations must be…