-
referencing using @row
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question. I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this: =IF(DidIncidentOccur@row = "Yes", 0, IF(YEARDAY(Date1) > YEARDAY(Date2), DaysSince2 +…
-
Retaining comments in an approval workflow
Hi i have an approval workflow that isn't quite functioning as i'd like. It works as follows: * A Payments Officer inputs data to a sheet and creates a row comment to add context * they then change a status column to "Awaiting Approval". * This send an Approval Request to the contact in the Approver column * The Approver…
-
Update Request - Accumulated hours formula
Hi All, Currently I am setting up a tracker for tracking weekly hours spent on requests that come in via a form. I would like to set up an update request that runs every friday (until task is marked as closed) to the assigned person who will enter the amount hours they spent on the task in the week just gone. I would like…
-
Webinar Recording available: Drive action with multi-step automated workflows
Missed the webinar? Review the recording in the Learning Center. Learn how to combine multiple automated actions that drive your processes forward. In this webinar, we’ll demonstrate how to: Streamline multi-step approval processes Archive or transition tasks with move and copy row workflows Customize what information is…
-
Moving rows to new sheet with proofing enabled
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartSheet (including the proofs) but we are unable to do so. Is there a work-around solution…
-
Updating (e.g. formatting) Sheets - Is there a better way?
Good Afternoon! I am 2 months new to Smartsheet and enjoying the journey thus far. Project Background: I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Master template which contains alot of formulas and conditional formatting, etc. Once I get it designed as…
-
HOW TO SOLVE INDEX MATCH WITH DATE TENURE?
This is Table 1 This is Table 2 The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month. After many research I have found a formula which can mach 2 criteria at once but its not working for add the amounts…
-
Feature Request: Smartsheet Desktop apps (specifically for Mac!)
Dear Smartsheet Team, PLEASE build desktop apps so that users don't have to rely on their browser to use Smartsheet. If you look at most people's browser, chances are they have a million tabs opened. That makes it easy for Smartsheet tabs to get lost in the chaos, which in turn reduces overall productivity and prevents…
-
The 'Send' and "Send Update Request...' functions are not working for our licensed users.
Did something change? We rely quite heavily on these functions. Any insight would be appreciated. Thank you very much!
-
Send a form out daily track responses on separate row...
We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites the previous response because it was a "request for update". We need to track each response separately. On the same sheet…