-
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
-
Tracking/Receipt for Sent Automated Emails
Currently we can set up an email automation but have no way to track that the email has been sent to the other user. If the automated email is terminating a contract, we would like to be able to provide proof that this was sent, should this be questioned further down the line… This could either be the sent automation…
-
Changes made to column titles
Automated flow when a cell or row changes exist already. I want to notify a person when the title of a specific column changes as it will effect dashboards that refer to the column title.
-
自動化メニューは見当たりません
評価版（Business Trial）を利用しているものです。 作成したシートに自動化処理を施したいのですが、自動化メニューが見当たりません。 当該シートのアクセス権は管理者です。 SmartSheet初心者ですので、トリビアルな質問ではありますが、どなたかご教示ください。
-
Make fields required in update request workflows
When creating an automation workflow from scratch, where we request an update, is there any way we can make the fields that they have to fill out required? What we noticed when we did this was that multiple people were not completing all the information we needed them to, so when we would see what was updated in the…
-
Merged: Choose another Automation Email
This discussion has been merged.
-
I Want to Filter Based on a Status and Date
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
-
Merged: Add Required Field Validation to Automated Update Requests
This discussion has been merged.
-
Inquiry on Smartsheet API update Requirements by this June 3rd.
As per the mail sent by Smartsheet team (June 3rd Deprecation), we verified that below API end points were not the part of the provided deprecated APIs. But cross verifying again, please help us to verify the impact of the below end points. a.Get Sheet – GET /sheets/{sheetId} b.Rename Sheet- PUT /sheets/{sheetId} c.Copy…
-
CountIfs Formula between two criteria
I am trying to do a formula that will pick up the tester and also if it is between a set of range of dates. I did one formula picking up the name, and one doing the set of dates. When I combine the two, I am not able to get it to work. Could someone tell me what I am doing wrong. I am hoping this formula will show the…