-
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
-
Disappearing Links
I had several links (URLs) saved in a sheet for quick access to frequently used resources. All of the links (URLs) have disappeared. Many links were to Google Drive resources. What caused the links to disappear?
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
-
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
-
Data Shuttle - Delete Rows No Longer In The Source File
I am trying to use Smartsheet and Data Shuttle to automate an open order report that we use. Part of the reason that we're trying to switch it over to Smartsheet is that we want it to be a living document, so that our buyers can write their notes for each order and see what is happening with other buyers orders should they…
-
Merged: Allow Drag-and-Drop Reordering of Summary Sheet Formulas
This discussion has been merged.
-
Merged: Enable Workflows to Reference Summary Sheet Fields
This discussion has been merged.
-
Automation to Post a Comment
Would love an automation where if someone inputs into a cell, it will generate a new comment.
-
AI Capability in Smartsheet Reports
I am able to use the AI functionality in Smartsheet worksheets but not in Smartsheet reports. I would love to be able to create a report and utilize AI functionality to analyze the data specified in the report that was created from a worksheet.