-
VLookup - Multiple Searching Criteria
Hi all, I am struggling to find a way that allows Vlookup to search with multiple criteria in two columns. Referring to the screenshots - On the worklist sheet my aim is to VLookup into the Forms Testing Sheet and the criteria be both the agent name (Row two on the Worklist) and The Week Numbers above (Row one on the…
-
Weekly checks and scheduled tasks
Hi There, my support team has to check 600 - 800 technical setups on a weekly basis. They have to approach all systems physically and do certain routines. We want to use Smartsheet and its forms to easily document that process and generate reporting. We would populate a list with all relevant information and generate…
-
Conditional formatting based on time from today
I want to create conditional formatting rules on a Date column and cannot figure out how to enter Today in the criteria Example: Select column = EOL Date is < TODAY = Red is between TODAY() and TODAY() + 180 = Yellow is > TODAY() + 181 = Green I can do it in Excel just fine but when i enter TODAY() in the criteria it says…
-
Creating a link that automates adding new cells into the sheet
On the current project I am working on, I am trying to use smartsheet to recreate an existing Microsoft Excel template that my company uses to collect data. At the bottom of the template, there is a cell that will create more cells at the bottom of the data set (ex. one region is working in 4 schools in quarter 1, but then…
-
Error when trying to add a user within the company
Hi, I am trying to add a user through User Management, but I get this error: "The user you are trying to invite is in a Smartsheet Enterprise Plan. To invite and Enterprise user, please contact sales at...." Any help is appreciated. Thank you, Deepthi
-
Archiving - Not Using Control Center
Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are very beneficial for the project history. My boss has asked to remove the status notes except for the current month and saved…
-
Pivot App - Transfer of Ownership
I was wondering what would cause the, "Error! Target user doesn't have sufficient sheet/report access.", error when trying to Transfer Ownership of a Pivot Sheet, from one License to another? I own both Licenses, and they are also Business Licenses. I have previously made 20 or so transfers, but I am having trouble with…
-
How to get attachment id.
I am using c# to try get the attachment id of an attachment in a certain row in order to download the attachment. How can I achieve this?
-
Only excluding the first weekend
Hi, I'm currently using a formula to spit out a certain number of days between two dates. I want to exclude the first weekend if it falls within the first 3 days, but otherwise include it. Currently to exclude weekends entirely I'm using =NETWORKDAYS([SALE DATE]21, [OUTPUT DATE]21) - 4 I'd like the formula to work like…
