-
Follow a Row
Hi There I was wondering if there is a way that a collaborator can follow a specific row? For example, they are not assigned the task, but it is critical that they get notified when there is an update or change to that task. However, they don't want or need to know about changes made elsewhere in the sheet. Many thanks…
-
calculating changes to duration value
I need to build a formula to calculate changes to the default duration value within our master timeline template. Ideally, I need to the function to notice a change to the default value and calucuate the increase or decrease. Any suggestions on the approach for this?
-
Linking Harvest hours to Smarsheet
Our company employees log all of their hours into Harvest. I see that you can send SmartSheet hours to Harvest, but I would like to pull hours from Harvest directly into my Smartsheets. Is that possible? Thank you!
-
Creating a report from a dropdown list value
I am trying to create a report that will pull in all rows that are under a certain value in a dropdown list. However, when going through the report builder, the dropdown list is blank (picture 1) although my actual dropdown list is populated (picture 2). Is this a known issue or am I doing something wrong? Thank you
-
Pasting into an Auto-number does not auto-number in sequence
Hi all, I just pasted a list of about 20 records into a autonumbered sheet, The auto numbers did not appear in sequence. The paste is as per the original sequence, the autonumber field, jumps around with out rhyme or reason? e.g the fields sequence 179, 180, 181, 184, 185, 189, 190, 191, 192, 194, 195, 197, 200, 188, 193,…
-
Conditional Formatting for Kanban Card View
When looking at items in Card view, conditional formatting is an option but you can't apply the formats to the card view itself. Is there a way to change the color of card based on conditional formatting? Current apply to rules only work in the spreadsheet view.
-
How to define a default value for a field with a formula
Hello Guys, I am using the webform feature to create the new record for my sheet. In each record, I have cells called Created Date, Closed Date and Duration. And the Duration is equal to a formula which count the gap between Created Date and Closed Date. f(x)=NETDAYS([Created Date]1,[Closed Date]1) The formular is working…
-
Scroll wheel not working with system settings
I swear I posted this somewhere else, but cannot find it now. Opening a new post. I am able to scroll, but I find that Smartsheet does not respect the settings of the mouse scroll wheel while I am in a sheet or report. If I go to the home tab, or scroll around in my favorites, I can see that one click of the wheel ~= the…
-
Smartsheet iCal - Publish By Filter
I am playing with the iCal publish and have a couple of questions: The Smartsheet Calendar allows me to add a filter for the items I want displayed. However, can I publish the filtered view to Outlook without changing the view for other people who have subscribed to that ics link? In other words, is there a way to get a…
-
Formula to calculate start date, from end date
Hi SS community, I am trying to write a formula to provide a date, 45 days prior to the start date. Ie. = [Start Date]1 - 45days Appreciate the help.