-
index match
I have a dropdown list with some names and my goal is to create a corresponding contact list with emails. Is it possible to select from the list of names so that the email automatically populates? Is is possible to use index match to achieve this? if not how can this be done?
-
How am I able to automatically move newly added rows from a sheet to a dashboard?
The sheet I am currently using feeds to a dashboard that displays weekly updates on 3 project management sites. I was able to add a report to the dashboard that continuously shows new rows of data when they are populated on my sheet, however; I need to be able to harvest the incoming data and separate it into each site's…
-
restrict checking check boxes
I have two columns with check boxes which I share with users. I want users to be only able to select one and not both. in other words if they check a row in column A, it prohibits them checking the corresponding row in column B. Any help would be appreciated.
-
auto number column
hi, I have an exisitng sheet and I'm trying to add an auto number column. There was an auto number column before but it wasn't working properly so I have delete it. I have the most recent entry at the top of the sheet and I would like the oldest item to be starting at 1 and top item to be the highest number. however, when…
-
Formatting in Formula Cells
I have two date cells that I have formatted as long dates (May 30, 2018) titled Contract_Begin and Contract_End. I want the formula cell to read contract begin date through contract end date (for ex: May 30, 2024 through August 10, 2024). However, the cell formats to 5/30/24 through 8/10/24. I posted the formula I am using…
-
Help to create the formula to take a row data from a sheet, and bring to the main sheet
I have a form that take users data. I need to compare a column data from this sheet with the main sheet and if match bring all row to the main sheet.
-
AI text summary of a sheet progress/changes
Imagine you are a project manager, managing multiple projects/sheets. You have set up a dashboard that aggregates information from said projects. To make things easy to your CEO and other stakeholders, you'd like to generate a 500 word status report for each project that can be included per project on the dashboard via a…
-
Formula is not returning the correct value in 2 scenarios - 75 & 101 based on data range
Here is the formula: =IF([Hot Route Mileage (Roundtrip)]@row >= 600, "No HR", IF(AND([Hot Route Mileage (Roundtrip)]@row <= 599, [Hot Route Mileage (Roundtrip)]@row >= 101), "CALL", IF(AND([Hot Route Mileage (Roundtrip)]@row <= 100, [Hot Route Mileage (Roundtrip)]@row >= 75), "Zone3", IF(AND([Hot Route Mileage…
-
Creating distribution lists in smartsheets
I am an admin on a workspace only. Without being a "group admin", is there a way to create a distribution list for a workspace only? I would like to avoid sharing my distribution lists to my entire company to avoid unnecessary distribution lists on the company directory
-
Baseline Visual in Gantt or Timeline view?
Hello! We have baselines set up on our sheet. Is there a way to show the variance visually, in the Gantt or new Timeline view - or is it only visible in that column as a number? Thanks!