-
Setting the Year Selection Range for Date Fields in Forms
When creating a birthdate column as a date-type field, the date picker in the form only displays years up to 15 years prior to today. We would like the ability to configure or expand this selectable year range.
-
How do all users populate in a contact column as I type?
We connected our new account to SCIM and added in all employees in the company to Smartsheet. As we are using a contact column in a grid, those people are not populating as we start to type their name. We are not able to find information on why this is not working. Does a user have to accept an invitation and log in before…
-
Formula help please
Hi, See below formula and snippet for reference - I want it all the same but the only thing i want adding is if the line is overdue then in the 'late booking?' column to show 'YES - OVERDUE SERVICE' =IF(ISBLANK([Planned/Proposed Service Date]@row ), "", IF([Planned/Proposed Service Date]@row < TODAY(), "IN PAST - ACTION…
-
Formula Driven Calendar App Data Grouping
I’m using the Smartsheet Calendar App with a connected sheet that includes two columns: Event Type (dropdown selected by users) Event Grouping (formula-driven, derived from Event Type and used for calendar color grouping) The Event Grouping column uses a formula to automatically identify the company name based on keywords…
-
Blocks for vacations
We use Dynamic View to report and schedule jobs for us (we don't use Resource Management). We don't use the calendar view as it would have too many assignments. I want to be able to put vacation times/blocks in so that my Ops manager will see the block as he schedules work weeks out.
-
Maxif Next Date to Review
Hi, I am trying to identify the formula for doing a maxif for date. I need to find the "next review date" for a list of documents. Here is an "excel" verison of it: Formula in H2 is "=MAXIFS($C$2:$C$12,$A$2:$A$12,$G2)" How cna I do this in Smartsheet?
-
AUTOMATED SORTING
When writing an Automation, can I sort the contents of the sheet as part of the automation? I know this was NOT available for a long time, but I have read and heard that it is now available (Chat GPT thinks it is an available option), but I do not see Sort as an Action… Am I hearing rumors that aren't true? Or am I just…
-
Removing / deactivating user on USM
Since we no longer manage users int he 'User Roles & Reports" section and instead add in the 'Seat Types and true-up' section….when someone leaves the organization - how do you now: Transfer Owned Groups, Transfer Owner Permissions, Remove from Sharing, Remove from Groups, etc. that you previously did from the User Roles &…
-
MAXIFs Alternative?
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an Index/Match formula to display the most recent entry for that material. I would like…
-
License for Update Comments?
Hi! We have a project management team that has created a very thorough tracker through smartsheet so most meetings are very quick and to the point as it is but, I was wondering if we could be even more efficient if I have people that are completing the individual tasks comment on the line item to give their update ahead of…