-
Conditional Formatting not working as expected.
Hi, Excel: 2016 Version. I am creating conditional formatting dynamically from VBA with the below code every time when I opened my excel. The rules are getting created, but they are not highlighting the max and min value in a row (conditional formatting 3 and 4). I am so confused, anything I am changing in this code is…
-
Functional Requirements in Smartsheet
Hello, Our project team recently transitioned to Smartsheet. I am currently deciding how we will develop Functional Requirements (e.g. Excel, Smartsheet, Word, One Note, etc.) and eventually test cases. Is there anyone using Smartsheet in this capacity who would be willing to share their experience (pros/cons) and template…
-
Automation 'Copy to another sheet' doesn't work
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field…
-
Creat formula to evaluate date difference in working days
Hi All I'm looking for inspiration on creating a formula on separate sheet looking at data and dates from another. For this example, I have left on one sheet to demonstrate. I essentially have to complete all my projects 10 working days before Bom S Date starts and if not I need to flag up the QTY of projects and which…
-
Baffled......Circular / Blocked Reference (Vlookup)
This one is baffling. I have a problem with 2 sheets reading each others data through a Vlookup. Each sheet has Vlookup ranges from the other sheet. I understand why formula and Vlookup may return a #circular or #blocked reference, but I don't understand why my sheets work perfectly for periods of time, and then start…
-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…
-
How do i make an empty or blank cell equal "$0.00" in Smartsheet?
I would like to make certain columns on a sheet that has empty or blank cells to show $0.00, rather than being blank. Can I create a formula that says "if a cell is blank, make it show $0.00"?
-
Automated Workflow - Alert Notifications
Happy Friday SMEs! Is there a way to confirm an automated workflow "Alert" actioned properly. For example, when generating an "Update Request", you can validate if/when the request is completed by referencing the toolbar highlighted below --- Is there a similar feature (or mechanism) to track when/if "Alert" workflows are…
-
Transferring ownership
Hi there, I get an error message when trying to transfer ownership to a collaborator with admin status. Any ideas about the best way to transfer ownership of the sheet? I may need to transfer ownership of the workspace down the line. Best, Esperanza
-
I used automation and move a row and the row disappeared off of my sheet but did not appear on the t
I do not see an error log, additional columns headers were added to the the target sheet but no data ever appeared. how can i find out if there was an error or even see my data? I changed it to a copy so I would not "lose" any more data until I got it figured out.
