-
How do I personalize what i see in the calendar view for each event?
I am trying to recreate a calendar with 2 major events. Each event has sub-tasks with different start / end dates and different participants. For example Event 1 is France and Event 2 is Italy. Each main event has different sub-events with different dates and participation 1. First I would like to change the color of each…
-
Field Master document & best practices
Can you help? I'm trying to figure out how best to document a Field Master sheet that tracks field availability & logic (business rules) for a Salesforce CPQ implementation. Dimensions: Quote Type (~15) -> Currently multiselect column Quote Path (Original Quote, Amendment from existing Contract, Amendment from Contract in…
-
Best way to duplicate a batch of tasks across divisions?
We've launched a program made up of multiple projects recently and the management team wants to see all of the subtasks for those projects repeated across multiple divisions. Is there a way to templatize or repeat a group of tasks across multiple divisions or business units and keep everything in sync? Sorry I'm a bit of a…
-
can i set up single automation to update a column in multiple rows at once
I have a parent row with a list of inventory within the child rows, with quantities of the inventory. I want to set up an automation where i can send out the list of inventory and update quantities used with in. Is this possible? Updating the circled column within one automated request
-
Form has a "contact" field, but not ALL contacts appear in the drop down for all users.
I have an Update Request (Form) that contains a Contact column. When typing a user name into the Form, I can see all contacts (suggestions in dropdown) but other users cannot. Also, on that same sheet, there's a second Form that contains a Contact column. The users can see all contacts on that Form. How is this possible?
-
Auto Number Reset
Is there a way to reset the auto number to 1? I've been testing formulas on this sheet and even though I have deleted the lines it is still counting them. Is there a way to reset it?
-
Formula to lookup prior cell values
...and not require use of the API*. Often, people want to create Smartsheets that use or track values of cells in a(nother) sheet over time, or look up a prior value using a date, or a date formula. The VLOOKUP function could be enhanced to do this, taking a date argument. Or, a separate function created to be used in…
-
Gantt chart generated from report - group not showing when printed
When I print or pdf, the groups disappear and only the rows are shown. Hi, I need to print a Gantt chart that was produced from a report. The report is grouped (see the group "Corporate" in the example below). When I print, the groups disappear and only the rows are shown. Without the groups, the reports don't make any…
-
Cells Changing Colors - Unknown Reason
I have a few sheets that I'm working on that when I add a column, cells below that new column have colors on them. Most of the cells are dark yellow but one is green. I do not have Highlight Changes on, nor do I have any Conditional formatting on these sheets. I've never seen cells do this before. I have some automations…
-
Smartsheet Bridge
Hi, I'm on Enterprise Plan and I'm trying to use Bridge but cannot log in to it. I actually had to dig the login link from the forums because I could not find it anywhere else, and when I try to sign in using my Smartsheet account it says "Unable to log in with Smartsheet credentials at this time, try using Bridge…