-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
-
Add Stacked Area Chart type to Dashboards
Please add the Stacked Area chart type to Dashboards (available in Excel)
-
What is the best practice to manage adding features and changes to Smartsheet?
We are working on adding testing and change management to our Smartsheet instance. What are best practices for managing changes, and having a Dev to Test to Prod style workflow? How are others managing test data and automations that are not in production yet? We are working to add additional functions to our projects,…
-
入出金履歴管理の設計について
個人単位の入出金管理について、設計の相談です。 Aさん〜Gさんなど複数名の入出金を管理しており、
以下のような構成を考えています。 ・シート①：全員分の入出金履歴（1行＝1取引） https://app.smartsheet.com/b/publish?EQBCT=63bab2005ccb46e5922aac9efd9bf560 ・シート②：名簿（個人マスタ） → 名簿側で現在の残高（SUM）を確認できるようにしています。 ・レポート①：個別の入出金履歴 https://app.smartsheet.com/b/publish?EQBCT=f090df15bdae4df894da7fc4ae26dfa2…
-
Merged: Reports: Add Filter Option for "Current Month"
This discussion has been merged.
-
Flag first occurrence as “Unique” and others as “Duplicate” by person + date
Hi Community, I’m working in a sheet with a bunch of historical data that has these key columns: [Personnel Name] (staff contacts) Date (date) [Duplicate Check] (text, where I want the formula to live) What I’d like to do is: Treat each combination of [Personnel Name] + Date as a group. For each person+date group, mark…
-
Is there a way to show a report of duplicate names across multiple sheets?
Hi all, I have about 6 sheets that act as master rosters for 6 different programs. I would like to have a report that shows which individuals show up across those multiple programs. Is there a way to filter a report to only show those individuals or is there another way of doing it that might be better?
-
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
-
Month Function Sorting in Report
Hello! I have a sheet that captures items and their start/end dates in a date format. I am trying to create a report that will group the items by the Month that the item is taking place in chronological order (Ex: All items with the target end date in January would be grouped under "January", followed by all items with the…
-
Inputting Contacts into Smartsheets
Hi Smartsheet community, question..my Smartsheet account is not allowing me to input contacts of contractors for project into my inspection reports. I have the correct information for each contact (ie. email and phone number). Would this be a restriction out in place on my company’s end or..I need answers. Any feedback…