-
I am trying to get the last Monday of the month from a date using a formula.
I am working on a project where I want to use a formula to return the date of the last Monday in a month. For example, if I have a cell that says 4/11/2024, I want a formula that will then return 4/29/24 (because that is the final Monday of this month).
-
capture name of cell modifier in a cell
When a cell value changes, capture the contact name of who modified the cell value. This would be much similar to the record a date when cell value changes automation.
-
Smartsheet Automation Trigger AND Capability
Right now, the Smartsheet Automation Trigger allows multiple criteria but the default in the statement logic is only OR. There is no option to replace OR with AND. Can you please add this?
-
特定の列のみを別のシートにコピーしたい
こんにちは。 元のシート(シート①)のチェックボックスをONにしたら、その行を別シート(シート②)にコピーするAutomationを使用しています。 今はシート①のすべての列がシート②へコピーされてしまっているのですが、シート②へは「シート①に含まれている特定の列だけ」をコピーされるようにできないでしょうか。 シート①で列を増やすと、シート②へコピーするたびに、勝手にシート②の列が増えていってしまうのを制御できないかと考えています。
-
Why can I edit on my phone but not on laptop is read only
-
Need formula & function for the question below
If I apply for PTO, I want to make sure it's getting subtracted from the "WR Balance Before Application" and it would be straight subtraction selecting cells & it's sorted. The main formula I am looking for is, If I apply again, my "WR Balance Before Application" should be the latest "WR Balance Left After Application"…
-
レポートで列をmergeして表示できますか?
2つのシートに記載されている内容をまとめたレポートを作成したいと考えています。 シート①:IDが付番された案件についてA1, A2, A3,・・・A10と10列の項目について記載あり シート②:IDが付番された案件についてB1, B2, B3,・・・B5と5列の、シート①とは違う項目について記載あり このシート①とシート②の項目の中から希望の列(例えばA1, A2とB1, B5)を表示させるレポートをシート①とシート②を使って作ることはできますか? INDEX,…
-
User Inconvenience regarding label navigation bar
Hi, We are using so many sub-labels in Brandfolder, so we have almost 900 labels in total. But when we click lots of labels to look for some assets, leave Brandfolder, and get back to Brandfolder later, the label navigation bar are being kept unfolded as the way we clicked them, which is very unconvenient. Is there any way…
-
Resource Management panel icon - not appearing
Hi, I'm wanting to start using 'Workload tracking'. I've read the learning resource below and set up a new project sheet, however the 'Resource Management panel icon' just isn't appearing. This panel appears to the first step to setting up Workload Tracking. I've reviewed the Smartsheet community, but can't find anything…
-
Resource Management and Calendar connection
I have field employees that I need to communicate their daily/weekly schedule.Im currently in the process of setting up RM and have the premium calendar app. I'm assuming that they connect but I could be wrong. Does anyone know if they do connect or do i need to connect each Project sheet to the calendar? any clarity would…