-
IF(AND formula
Hi, I am using this formula =IF([Warranty Status]@row = "Warranty Expired", IF(AND([Asset Status]@row = "In-Stock), "Out Of Warranty","")) Its says the formula is unparseable. I can't figure out the issue with the formula. Help is appreciated.
-
Burndown Chart
Hi Everyone, I have a question about how to drive a burndown report in a Project summary: I've built a burndown sheet that contains the Application Name, Baseline Finish, and Actual Finish dates. (Those three columns are linked to other project schedule sheets.) I've also built a Cutover Date column that lists every…
-
Need both Text and Contact List versions of people on same sheet
I have a PowerBI report that pulls data from a Sheet. When I use a contact list on the sheet, the email address shows on the report, not the name. The customer wants to see names, not email addresses. I need the contact list column because I have reports that filter on logged in user. I don't want people to have to enter…
-
Edit Smartsheet or Excel Template (can't locate)
I started using this smart sheet for study planning. I work FT and have a demanding study schedule. I needed to add time to the sheet (15 min. intervals would be preferred) but I can't figure out how to adjust it. I also can't locate this template anymore. Uploading for reference. A tally at the end (sum) for total hours…
-
construction cost estimate for installations
Can someone help me and give me an idea on how to create a cost estimate for installations, with a total for each chapter by groups, subgroups and types of work, but at the bottom of each chapter. https://us.v-cdn.net/6031209/uploads/0OSH46KSC2LH/cost-estimate.xlsx Thanks
-
Contact List showing as a text only
It happened suddenly. It was working last week. I'm using Index Collect to pull a contact as cross sheet reference. But today, I did not see that working well. Usually it has circle beside my name, suddenly it vanishes, and it just contains text. I'm using those other columns to be sent notification, and it doesn't work…
-
Copy Rows according to Multi-Dropdown
I have an Intake Sheet in which someone can select multiple Locations and multiple Fiscal Years that the Initiative will occur in. What I need is for this row to copy to the Retail Master Sheet a total of 6 times - one for every possible combination of the selected Location and Fiscal Year. DESIRED RESULT - My current…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Dropdown List Alternative with Automatic List Update and Dynamic List Features
There have been many requests for improvements to the Dropdown list from Smartsheet Community. The two most typical requests are Automatic updating of the list @Justin Mauzy @Taylor Compton - NOAA Federal Dynamically changing the list of the following selections based on previous selections @Ian Cooper @Mehran Bagherian…
-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?