-
Trying to redirect to a second form following answer in a primary form
Hello, I created a sheet with a form , there is a specific field and following the answer in the field , i would like to have a redirection to a second one linked to this field. Ex : sheet Project , with a specific field Domain , if Digital is entered , a line is created in the second sheet linked to the domain digital and…
-
Trying to redirect to a second form with a field already filled out
Hello, Is it possible when submitting a form to have it redirect to another form that contains common field and have the common field be auto populated using a query string? https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values I understand that you can use a query string to have a field be…
-
Smartsheet Template for manage our sales procesesses, steps and gates
Hi all, My first time in smartsheet community. I'm looking for a template that can help us manage our sales processes within the sales department (offering large Biogas plants). Today we have implemented 12 specific sales steps, designed to ensure quality and adhere to guidelines in our sales activities. Each of these…
-
Planned vs actual progress (hope this can help you)
Hello everyone, I'm a little bit new on smartsheet and the first thing that I faced was how to measure the variance of my project, I tried the forum, youtube and help from this page to get what I wanted, it was not what i expected. So to get that visibility I decided to ad a new column (% Planned) that shows the…
-
Multiple dates in a single sheet
I am having trouble tracking my project due to frequent date changes. Can I track the original and actual start/end dates?
-
Conditional Formatting in a Report
Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!
-
How do I overwrite or replace a sheet which is linked with multiple reports/reference sheets etc,.
I have a master data file which has around 20000 rows with nearly 10 columns (200000 Cells) Data driving several reports (50~60), reference formulas to several sheets (8~10). Master Data file changes (200000 Cells) everyday (Adds/Removes/Re-arranges data). In excel, we just save the file under the same name and it gets…
-
Red, Yellow, Green, Gray automation formula help needed for numerical ranges
I have a column called "metric data" and I am trying to create conditions for the status column (Already made it a symbols column) for Gray, Yellow, and Green Green = 1 (100%) Yellow= 0.01- 0.99 (1% to 99%) Gray= 0% =IF([Metric Data]@row = 1, "Green", IF([Metric Data]@row <= "0.01- 0.99", "Yellow", IF([Metric Data]@row =…
-
Print report - Summary Totals not showing on PDF
Hello. I have several reports with Summary fields defined within the Report file. My question is, why aren't the Summary fields showing up on the printout / PDF version of the report. I see the Summary fields on the Report file, but they never seem to show up once I select the Report to print. Suggestions? Thank you!…
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…