-
Cell Link from web form
Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet. I used the workout of providing the cell background color to white to…
-
Populating webforms with data from sheet
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking "submit" the sheet is populated. This works fine. 2) A webform is then created from the cells in the row corresponding to…
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Conditional Formatting For 11 Months From a Date
Hi Everyone, Thanks in advance for the help. Here is what I'm trying to accomplish. A service is sold on a specific date. We want a "timer" to start that will highlight the row yellow when it's 2 months from expiring. We want to highlight any row within the 10 month window from start date to be green & dates beyond 365…
-
Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…
-
Notifying multip;e folks when a change is made to a specific ow
Hi We're a construction company and change orders are a nightmare when not tracked properly. We're working on a "from the field" change order system and I'm the sales/estimator. What I'd like to do is once I get notification from the crew that a change order needs to be generated, and then inform the bookkeeper, lead…
-
Filter - "at least one condition" - wrong results
Hi, I may be going mad, but I cannot get a filter with at least 1 of 2 conditions to work. Maybe my boolean is getting rusty... I have 2 columns with monetary values. I only want to show rows where at least one of these is bigger than zero. Nothing complicated. The settings are attached in the screenshot below. However I…
-
Sending Attachments
I want to send/share a row with someone and I want them to be able to see the images in the attachments without having to open them. For instance, I need to send a General Contractor a Weekly Report of work completed. There are attached images on a row that need to be sent to him. I could share the row, but it would not…
-
Create a report form from single line entry
Hi, we use Smartsheet to track customer requests and action plan to resolve. I am setting up a webform for quick entry and would like to print a "report" or something that is easy to pass on to the appropriate person. It would need to be for only one line on our smart sheet page. I know I can click on the line and "Send" -…
-
Zapier and Service M8 integration with Smarthseet
Hi, I was wondering if anyone has any info on how to achieve what i am trying to do: I have field management software that I use called Service M8 - it works with Zapier to update and or create rows in Smartsheet. We use Zapier to make a new row in Smartsheet and the trigger is when we make a new client in Service M8. That…
