-
If a match is there, insert data from another sheet to main sheet.
I know that this is so simple, but I can't get it to work. Scenario: Sheet 1 (main data file where I want data to be imported INTO) has a location name column and an address column (currently blank). Sheet 2 has the listing of location names and addresses. Need: If the location name on sheet 1, matches the location name on…
-
Pictures in Forms
Hi I know this question has been asked a few times, we require Forms that have embedded pictures (which guide the form "completer"). At the same time, we prefer a form creator that has a Smartsheet integration, as we don't want to introduce an additional layer of complexity. Does anyone have a suggestion? (We tried the…
-
Call ups and reminders
We are residential builders and I am trying to set reminders for call ups. For some reason I am not able to access dynamic reminders, where I can choose how many days prior to the task I want the reminder. Just wondering how other people do this or do you have the same problem?
-
Error with Form entries
Some has experience a issue with this type of errors in entries submitted in Smartsheet forms: It seems it something about formulas in the Smartsheet source but, we don't have formulas in every Column: Any help will be highly appreciated! 😥
-
Customized Data Entry Views
We have master sheets with over 100 rows and it gets very labor some to enter data at different phases of a a project. I understand that form views are a nice way to enter data but that they can only be used one entry per row. Is there a way to go back into form view at a later time and by a drop down menu of the primary…
-
Can I change who an update request appears to be coming from, or send one on behalf of a teammate?
Hello, I have a database of recruiting information that I want to update for the coming academic year. There is a column for the recruiter email, and I'd like to send an update request to the email contact in each row, but I'd like for that update request to look like it's coming from the member of my team that manages the…
-
IF AND with Dates
Help! I've searched and I am stuck! I'm new to SS and I cannot get any formula to work. Here's what I'm trying to do; If the status is "In Process" and today's date is greater than 7 days from the due date = Green If the status is "In Process" and today's date is within 7 days of the due date = yellow If the status is "In…
-
Trouble adding a cell value to Workday function
Hey guys, I'm having an issue using the Workday function that I was hoping someone can help with. In my sheet, I have a text/number column that calculates number of days based on resources and work remaining. What I am attempting to do, is add that number to a start date in order to show the end date, however I want to use…
-
HELP Nested-if Formula
Hi there, I'm trying to complete my certification and the following nested-if formula needs to be created: "Use a nested-if formula to automate the RYG light in the "Status "column, depending on the "% Complete" for each request If a request is less than 70% complete, turn the Status column "Red" If a request is 70% or…
-
Index Match Showing Incorrect Amounts - Formula when there is no information to pull
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
