-
Creating project in Resource Management from a Smartsheet Report
Hi All, I would like to get data from a client's Smartsheet into Resource management, however their work is not formatted properly for me to be able to do so. In addition, there are rows of info that are not relevant to my team. I could make a report to pull the data I need, but I cannot create a project for Resource…
-
Add required number of columns at once
Hi If you can add a feature to add number of columns at once it will be helpful. Thanks
-
smartsheet API key is not able to fetch data from the smartsheet having MFA.
I am not able to fetch data from the smartsheet using API key which is having MFA. I am getting an error - "This action is restricted by an MFA Policy. Please reach out to the workspace admin for any questions.". How I can resolve this issue?
-
How to pull information from a cell on another sheet
I am trying to search multiple other sheets for information to pull back one cell of information. The formula I was attempting to use was =IFERROR(INDEX(COLLECT({Quote Log 2024 LCI SO}, {Quote Log 2023 LCI SO}, {Quote Log 2022 LCI SO}, {Quote Log 2021 LCI SO}, {Quote Log 2020 LCI SO}), ({Quote Log 2020 LCI Quote #}, {Quote…
-
Dropdown Date Automation
Hi I am trying to automate a date being added when a dropdown value is changed, each value would have its own column for dates, I also want to be able to backdate this as I can see where previous columns have been changed, For example if a column changes from Dead to In Discussion to Live, I want all those dates noted down…
-
Automation sending emails without conditions being met
Starting a few days ago, I am receiving automation emails from Smartsheet for conditions that have not been met. These workflows were implemented several years ago, and have never had a problem like this. I went and triple checked to confirm the conditions are not met. I deactivated the automation and reactivated thinking…
-
Reply to a comment without @ should send notification
When person A enters a comment on a row and person B types a reply, no notification is sent to person A unless the @ feature is used in the reply comment. Most people do not know this -- the expectation when you reply to someone's comment is that a notification will be sent since you are replying directly to their comment.…
-
Formula help, combine and convert to lowercase
I have a formula, =[Player/Number]@row + "_" + [Product Program]@row + "_" + Gender@row + ".pdf", I would like to add to the function to convert it to lowercase as well, any help?
-
Index(Collect( Formula Help
Hi, @Genevieve P. appears versed in this issue from the previous posts I've read. I've read several posts from 2020-2021 about how to do what I'm trying to do but I can't get it right and I'm hoping somebody can easily fill in the blanks of this formula. I essentially want to VLookup based on the value in 2 columns. I've…
-
ENGAGE London agenda + a special message...
Hey all, the ENGAGE London agenda is live! Because we love a celebration around these parts, click play on the video below to hear a special message from someone you might recognize if you've attended ENGAGE Seattle: Zak Brown, CEO of McLaren F1 Racing. And if that didn't get your engines running, I'm excited to tell you…