-
Google Calendar
With the Google calendar refresh coming out on the 28th does anyone know if we will have to re-publish our smartsheet calendars to Google?
-
Drag fill across colomns
I have a sheet with 180 columns, each with a "add sum" *=sum([column name]:[column name]*. I am trying to "drag fill" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column? TY
-
Return "pending" if project lands between two dates
Hello, hoping for some help from the Smartsheet experts. I am looking to return "in progress" if a project lands between a project start date and project finish date. My start date, finish date and status are in 3 columns, side by side. Looking to automate the status column, to reflect in progress, when falling between 2…
-
Linking from a sheet that's reached the 5000 row limit
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximately 100 field employees. My sheet is up and running and is being rolled out to a limited number of supervisors during the…
-
Outlook Add-in
I'm wondering if there is a way to show more columns within Outlook when adding things to smartsheet via the smartsheet plugin, or if there is just a better way in general to accomplish what I'm trying to do. For example, if I receive an email confirmation for something and want to add it to the Task it is associated with,…
-
Finding a formula
I have a formula counting the last 8 numbers in a row. I have hovered over the cell and can't find the formula to copy it to another line what am I doing wrong?
-
keeping all responses from monthly update requests
I need to get some data from a partner every month. I have set up an update request to be automatically sent for that time frame, but I'm wondering ...does it add another row every time they respond to the update request? Or, when they respond to the automated request, does it overrun what was they had previously submitted…
-
DataMesh not finding cell links
I am having issues with DataMesh, as it is unable to look up the values between the sheets. I checked some of them manually, and the numbers exist on the target sheet. I also tried to export into Excel and test this formula. Excel required a re-format of the numbers (text to number format) before it was able to…
-
IF(AND..........also ISDATE combo help please
Hi Team, I'm attempting to build a formula that requires three parts (I Think). The attachment below demonstrates in simple terms. When the production manager enters the date ("90 Day Defects Period") and clicks on the drop list ("PRODUCTION Job Status" and choose ("DEFECTS 90") the 90 days period will kick in. I want to…
-
Sharing a subset of a smartsheet
I'd like to hide from view various rows when sharing my smartsheet. Is this possible? Thanks, Mike
