-
Is there a way to use a formula to tell my contact cell to populate based on another field?
So, I have my team member names populating in the sheet with just their initials - but I want to be able to tell the sheet that if those initials are in the "team" field, then add this matching contact to the "Assigned to" field. Is there a way to do this? I can drag the names down, but just was hoping for an automation
-
Referencing the last comment to update a column
Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet. I'd still like to use the comments thread so other Project Stakeholders can reference the communication for each…
-
Why is my multiplication formula invalid?
I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55"))) This formula works well, however if I then try to use those values in another formula is just…
-
How to Use VLOOKUP and SUMIFS
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on…
-
How are you currently using Smartsheet for Marketing?
Hello fellow marketers! My name is Kevin Branscum and I am the Marketing Solutions Manager here at Smartsheet. I've spent my career in various marketing roles (brand marketing, product marketing, creative project management) and have been using Smartsheet in most of them. For my first question to the group, I'll keep it…
-
Is there a function to have google sheets and smartsheet to have a live active link?
My company currently has two separate department that uses two different systems. My department is using Smartsheet and the other department is using Google Sheets. Is there a way for the two systems to communicate with each other with links and formulas?
-
Dashboard Card View with persistent filters
I have a dashboard with two web content widgets of the same sheet using a card view. I want to be able to have one only show the completed cards and have the second only show the in process cards. I have successfully created filters that can be used but I don't want the viewer to have to select the filter. I would like the…
-
Is there a formula in smartsheet that would create a 2 way link between cells?
Hello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if the other sheet decides to change the cells, it would reflect back to the Master Sheet.…
-
Budget v. Invoice Cost Codes
I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amount from each invoice and have them populate in my budget according to their cost codes. The budget amounts for each cost…
-
Trouble with COLLECT in INDEX/MATCH
I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for the "next deliverable" - we have a column called "Function" in which the schedule tasks can be defined as such. (See…
