Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Webform - Changing color for healiners, email,
First request, it could be helpful to have the heading “Required Information” in red font so it stands out. Feedback from the Controllers reaching my desk indicates that xxx had to verbally point those out to the controllers, so please let’s work on rectifying that. Also, under “Required Information” the person submitting…
Using Hyperlinks from mobile app
I have hyperlinks on a sheet that hyperlink to other sheets. When I click on them using the mobile app it opens up the row for editing instead of opening up the hyperlinked sheet. Any help on this?
Log A User Out Remotely?
Is there any way to log a user out remotely? Someone with high priviledge who is away for 2 weeks has clearly set her PC to remember her log on details. Can I log her off and reset her password remotely? I have currently removed her priviledges as an immediate security measure. Thanks
Sharing - keeping info confidential to relevant parties
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this…
Time Tracking
I thought I would share my take on tracking time in smartsheet. Use the checkbox and save features to test the formulas out and see how they work. https://app.smartsheet.com/b/publish?EQBCT=77c33874736d40a78495cf4d4169365f Of course this would be useless were the current time and not just date to be able to be used, but…
Update status field based on End date and %completion
Hello All, I would like to do some conditional updates in smartsheet based on below: 1) I want status field to reflect Green if End data of task is greater than today's date 2) I want status field to reflect Red if End data of task is less than today's date and % completion is less than 100%. 3) I want status field to…
If & AND equals checkbox
Cant get my formula to work =( Please help =IF(AND([Team]28 = "Street Lighting", (NOT(ISBLANK([Quote Sent Date]28)), 1, 0))) If Column 1 (Team) contains text "Street Lighting" and Column 2 (Quote sent date) is not blank, Check the box Thank you in advance
Workspace Ownership Change Notification
I would like to be notified when ownership of a workspace is changed from me to someone else.
Formating in Smartsheet
Cell merge function I have seen that this function is still not in place. Can anyone tell me when this function will be implemented? Or is there a way, where I can use a text in one my Project templates with an instruction text to guide someone through within my template, for example my due diligence questionnaire (DDQ),…
Filtering Older Data
I was wondering how to use smartsheets to filter out older data in a log. For example in a purchasing log, what I did at first was creating a checkbox column with cells such that a order that arrived for longer than 2 weeks will be filtered out: =IF(AND([Last Modified]1 < TODAY(-14), Status1 = "Arrived"), 1) That function…
