-
SUMIF IF referred sheet/column ISDATE
Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
-
Is there a solutions gallery?
I am in the trial phase and I like smartsheets. However, I am overwhelmed with the many *single* or standalone sheet templates available. Unfortunately, I did not find any "complete" workspace templates with interconnected sheets and reports and sights. Probably you would call that a solution? Is there a way to import a…
-
Adding additional Attachment and Comment columns
Hi! Just wondering if it is possible to add additional attachment and Comment columns within the same sheet? I work with a lot of cross-functional partners where attachments and columns may be important to different groups. With notifications being set up, it makes it hard to differentiate. Thank you!
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Comments in report widget
I have a report pulling in the info I need from a master, and then am using the report widget in my portal to display the contents of the widget. However, within the report widget I can't see the comment bubble/view comments. Is there a way to see comments from within the portal? Thank you!
-
Comment Boxes
Question – We have created ‘contact sheets’ to track an employee’s contacts with clients. We utilize the comment boxes to track specifics. If we would like to transfer just a line (not the entire sheet) from one employee to another, is there a way to also copy or transfer the comment box?
-
Linking to a Smartsheet functions
I've seen posts that contain links that create an action, such as "click here and a copy of that sheet will appear in your instance of Smartsheet" I cant find the OP, and cant recall if she was staff perhaps, but the link worked. Is it possible then for me to create links to actions, for instance a link from that would…
-
Feature Request: Allow a Comments field for the entire sheet
It would be great if I could look at the sheet properties and have a section to place a comment pertaining to the entire sheet - sometimes it's useful to have a note on the purpose of the sheet and other useful information for users. The comment would apply to the entire sheet not just individual rows.
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Not all rows are fetching from my Python Script!
I have written a script to fetch all data from a Smartsheet. i am using Smartsheet's get_sheet('sheet_id') method to fetch my Smartsheet, which has 500 rows but i am only getting exactly 300 row objects, after 300 row objects an error like this being thrown "Too large to show contents. Max items to show 300". But the…
