-
Countdown from today not working
I am having the hardest time using any kind of formula...whenever I type them in I get the unparsed error. I am trying to do a countdown from today to an end date but no dice. I find the explanations on here for how functions work aren't really helpful for me. I have turned on and off the duration function, it gave me a…
-
Exporting Smartsheet calendar to Outlook 365
I'm struggling to export Smartsheet Information into Outlook 365 calendar. I'm trying to create a group calendar specific to resources(people) assigned to task(s) within my SmartSheet schedules so to have each individual assigned to a Smartsheet task in order to get an overall view of each persons time spend on multiple…
-
Automating the Date on Forms
I have set up a new form for customer orders with a 'Date in' option however, I would like it to be set to todays date automatically. Is this possible or will we need to fill todays date in each time an entry is submitted? Thank you in advance!
-
Changing the Color of the Submit Button
I am looking for some help as I'm new to smartsheet and still learning the ropes. I have embeded a form into a Wix website for a client however I would like to change the colour of the 'Submit' button to fit in with the website aesthetic. Can anyone let me know if this is possible and if so, let me know how to edit this?…
-
All technicians preferred old Grid view...
Since smart sheet update new version. We are used to able to look details with Grid view.. Now we have to review with grid view and then go to list view and able to see detail...it makes more longer time operate n more comfusion..please we prefer before version smart sheet
-
30 60 90 Initiative sheet
Does anyone have a good/great template/report or dashboard already created that you are willing to share. I am new to smartsheet and have ideas....but limited time to put something together. It is for and acquisition project. Currently have a WBS by functional area...need to quickly strip strip key tasks & milestones out…
-
Report showing resources and assigned projects
I'm looking for help developing a report. I've got multiple projects and multiple resources working on those projects, and I'd like a simple grid - resources in a column, project names across the top, and an x indicating which project each resource is working on (or something like that). This view will give a snapshot of…
-
Stale time/date
Hi, I am trying to setup a "Stale" notification for a help ticketing system. When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notification. I can compare two different date columns like this: =Modified1 - [Created Date]1 But if I…
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Smartsheet and JIRA integration
Hi, I have two questions related to Smartsheet and JIRA integrator and I'd like to know if somebody here could help me: ** Question #1: Is it possible to insert a row (automatically) within a parent structure from JIRA integration? For example, suppose I have this smartsheet: Marketing Team Tasks Task 1... Task 2... Task…