-
Bring in data to new sheet
Below is a screenshot of the target sheet cell (Created on : etc) I want to update automatically when the source sheet is changed We currently have a cell link, but this is not updating without removing the cell link and redoing it each time. Here is the source sheet screenshot:
-
Pull dropdown menu options from one sheet into another based on a defined cell
Hello, I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B…
-
% in formula issue
Good morning, I have a column which named "% Complete". The next column, I wrote: =IF([% Complete]@row = 100, "Complete", "Not Complete") That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's…
-
Countifs + Distinct + Contains
Looking for some help folks if anyone has any ideas I have a grid of marketing content by market, some of which are the same content in different languages. I want to count the content types by market but only unique content, i.e. I dont want to count the same piece of content in all languages. I've tried this -…
-
Join Collect formula for multiple values
Is it possible to use a Join / Collect formula, which references a multi-select dropdown list in one sheet to find and query an array of values? In Sheet 1, I'm querying a set of values however I can't seem to pull anything forward when multiple values are listed in the Client Name column. I'm trying to pull forward every…
-
Report not populating with formula column data?
Hello, I have a group of sheets that populate a report with date data. One of the date columns is a formula column that is constant through all of the sheets, used to track various processes to calculate a target end date. For some reason, the data appears on the sheet but does not populate on the report. It appears on the…
-
Trying to create an on-call schedule with auto-calc'd dates
I am setting up an on-call schedule for all of the teams in the department. I want the start dates to auto-calc based on the prior row for the same team. I used AI to create a formula and it works. But when I went to make it a column formula, SS says that the format is not correct! This is the sheet. This is the formula in…
-
Help putting data in the correct column automatically
Hello. I'm working with a worksheet where I'm trying to put a Workers management team into the correct column based on the Managers Management Level. I'm able to see the flow of an organization by using an INDEX(MATCH()) formula (=INDEX({Manager}, MATCH(Worker@row, {Worker}), 1), but how do I get the data to show up in the…
-
Perform Count on "Year-Mon" extracted from Created Date
I have a working sheet that utilises the Created Date functionality by Smartsheet (DD-MM-YY HH:MM). I am looking to count the number of rows for every Month in a separate sheet to see new rows added over time. to extract the year-month i have created 3 additional columns: Year (=YEAR(Created@row) Month (=MONTH(Created@row)…
-
Extract name from Team Column
I have a form where a user identifies all the people from different departments and input their names in the Team Column. There are times when people are not filling it out for various reasons (wasn't part of the team, forgot by the team member or the original created by user, etc..). I want to be able to check if the…
