-
Attachment - Folders / Subfolders
In the attachment section, would it be possible to have folders / subfolders? I would like to store and organize using folders. For example, I would like to group excel sheets together in a folder, create a folder for my pdf documents, and create a photo folder. Please see the screen shot below: (I am aware of the Box,…
-
Update Schedule on Mobile.
I am new to the forum, so if I am not searching correct terms please let me know. And if there is already a thread on this directing me to it would be very helpful. I was wondering if there is any way that I can actually update a schedule (finish dates), on a mobile device while I am walking a site? I have both Android…
-
Submitting a row to two sheets broken by SDK updates
We have a form on our site that adds a row to two sheets in Smartsheet. This broke in June at which time the form added a row to the first sheet, but failed in the API call to Smartsheet in adding a row to the second sheet. Example Code that submitted to the first sheet (this was not affected): protected void…
-
c# Form submitting row to sheet via API 2.0.x
I am using our website to submit froms to Smartsheet and am having dificulty following the C# explanations in the API documentation. The first is a simple form with Date Submitted, First Name, Last Name and Email (formulated Date, Text/Number, Text/Number, Text/Number respectively). I have not even added the variables in…
-
Calculate days since a bubble turned red
I have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days since a bubble turned red. This would tell me how many days it has been since a project…
-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Countifs with OR across multiple columns
Hello all, I'm a fairly new (2 weeks) smartsheet user and I'm trying to write a formula that will count several columns based on specfic criteria. I want to count the number of Open projects (status) that are associated with engineering by either person/dept assigned column 1 or 2, and are of a safety concern (category)…
-
Auto Link Active Directory Emails in SmartSheet
Looking for process or procedure to add when customizing a field to add a user from Outlook and have it pull from AD or Exchange
-
Best time tracking software for Smartsheet?
Does anybody know of a good time tracking software that I can integrate with Smartsheet? Specifically, I am invisioning using a third-party time tracking software and be able to link the information (i.e. billing to date, hours, etc.) to my Smartsheet spreadsheet or Smartsheet Sight as a one stop shop with various other…
-
Detecting Cell Changes, Modifying other cells on update.
Hey guys. So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur. The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1,…
