-
Dynamic View Scrolling Up after saving
Currently I created a dynamic view that allows users to input data to my database of information under the details panel. This has been working great but with one wrinkle. For people who I've assigned long lists of items to add information, every time they hit save to add the data the page scrolls all the way to the top.…
-
Setting up billing rates in grid view?
As a newbie, I'm trying to set up billing rates in Grid View by job title, but I'm finding the help documentation in SmartSheet lacking (see attached screen shot). Is this even possible in Grid View? Or is Gantt View the only option? Or, is conditional formatting the only approach? Any input or ideas would be greatly…
-
Automated symbol isn't switching
Hi everyone, I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal to 100% mark it green. This is what I got: =IF([Actual vs. Target Sq ft. Produced]@row < 0.9, "Red", IF([Actual vs. Target…
-
Issues with Cross Reference and VLookup
I have been trying for several days to get cross referencing to work, it is stuck in the processing status is what I have noticed. I even tried to use different browsers to see if that was an issue. In order to provide data for testing, I cut down my files to remove sensitive data and just included the necessary data, now…
-
ADD 3WEEKS, , 2WEEKS, 1WEEK AND 24 HOURS DATE
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another sheet is feb/3/22, so under Citrix Status 3weeks from the due date will show in that column and so on I appreciate your help Rob
-
workflow automation - rows aren't moving?
Hello, I created a workflow to move rows once a column status is changed to "complete" within any row. But the workflow didn't trigger, even when I manually changed the status to something else and back again, saved, refreshed, tried again. It finally worked when I moved the row to a different spot in the sheet (shifted up…
-
Docusign / Smartsheet | Supported Field Types
Does anyone have experience working with DocuSign "Radio Groups" and merging those fields to data inside Smartsheet? I have been utilizing the Smartsheet/DocuSign integration for several months with great results, but there are a few areas I am running into issues - this being one. I have application forms that have…
-
Conditional formatting
Hi All, i wonder if there is a formula to help me out to change the task color bar match with my Assigned to column
-
Automated workflow trigger not working
I have set up a series of simple workflows to change a cell's value based on data in another cell. If the source cell value is changed to "50%" for example, the destination cell will automatically be updated with the number 5. There are several different source cells being used, some of which are "yes/no", and some with a…
-
Calendar View from Grid with Linked Cell (as Dates) not Populating Calendar
I have a calculations grid that summarizes a large data set (populated by formulas against a main grid). To do this, I had to create helper cells that are rather ugly and should not be seen by my audience. As a result, I created a new Grid (Reporting Grid) that is linked to the calculations grid. It's a grid made up of…
