-
Day or month as 2 digits
Hi all - I want to use the day and month of people's birthdates to create user IDs. I can extract the month easily enough, but I want all of these to be 2 digits (ie. if it's June, I can extract '6' but I want '06'). Does anyone know how to get a 2 digit month? Thanks
-
Fleet maintenance template
Hi there I am looking for a template to adapt to assist us with machinery maintenance on the farm. I want to be able to record work done and to set reminders for upcoming maintenance tasks. I am sure someone must have already done something similar with smart sheet - any help gladly received. Andrew
-
Report - Not all Sheets Displaying
Hi. I've set up my first report to show tasks from multiple sheets with a date parameter. Only one sheet of tasks is showing. Wondering if there is an error of some sort in the sheets that are not displaying in the report. Thank you.
-
locking a task start date
howdie...how do I make sure a start date of a task doesn't move...but the end of the task does move if linked to/dependent on the end of a previous task that takes longer to finish? help please! :-)
-
Blank display value for Symbols type?
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the green Up, yellow Sideways, and red Down arrows. Issue is, also need to display a blank in that status column if none of the…
-
C# API Add Records from MS SQL Server
Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the column id. I see that there is Bulk Operations but very little documentation for it. This…
-
Columns on Each Page of Schedule
This seems like the simplest task but I can't figure out how to have the columns in my schedule (Description, Duration, Start, Complete) show up on each page. It is easier for the Engineer to read that way without having to flip back to the first page to see what task he's following.
-
Access Cell History Modified Date in a formula?
Is it possible to access the stored date of cell's modification in a formula? I need to send email notification when a process is marked complete by a user. I see that I can view the cell history, and there is clear documentation of the date something changed, but if I could access that data in a formula in a new cell to…
-
Batch Update Request
I would like to send update requests for different rows to the 'assigned to' field in a batch request. Multiple update requests at one time. My specific purpose is to send out requests for proposals and collect PDF responses along with other information about the proposal and template the process to apply to multiple…
-
Enhancement request - smarter autofill for dropdown menus
In a column using a dropdown list of options, it would be great if autofill was smarter - specifically, if it would suggest options based on any word in the list of options, not just the first word. For example: Typing "West" should bring up options like "Broadway Street West" or "Northwest Broadway" not just "West…
