-
Is character count in a cell is increased from 4000 per cell?
Hi, I just wanted to know if the recent enhancements of smartsheet has increased the character count per cell? I want to use nested if for around 70 products, satisfying each product name and I think that nested if is going to exceed the limit.
-
SIRI / Voice Assistants
Good afternoon. Is anyone familiar with how Smartsheet works with voice assistants? More specifically, can I input a new task into Smartsheet with Siri?
-
How can I autopopulate end date with months duration without using dependencies?
Hi all, I am trying to work out how to autopopulate end date of the project based on start date and duration I have in months. I am trying to avoid using dependencies as those do not support months, only weeks, and that is not an exact value. We have several hundred projects running at the same time so really going and…
-
COUNT COLLECT To Find Rows For a Specific Date Not Working
Hello, I have a JOB SHEET that shows jobs assigned to one or more persons in a "Resource" contact column. This sheet also has the dates for "Start" and "Finish" to determine the date range that the project will be worked on. I have a separate Sheet (Sheet 2) that is intended to return the number of projects a specific…
-
How do I use the task rollup report to summarize multiple project plans?
I am struggling to get data to show and the other threads on this topic did not help me. HELP!
-
Need for Forms Automation Workflow
It would help so much if there was a workflow that could send out the link to a form on a custom (daily, weekly, etc.) basis. Right now I have to create a row that triggers the form to be sent weekly and just put the link to the form in the message and then hide all the columns so the row does not show up in the email.…
-
Index/Match or Lookup - return column from row where "x" matches and is the most current
Hi All, I feel like I might just be missing some simple solution here... but I'm wanting to lookup from one grid into another where I keep some subset data and there will be multiple rows that match the lookup value, but I want it to return the one where the date (in another column) is the most current. It works fine when…
-
I am trying to figure out how to export to excel without the "Comments" worksheet for each.
When I export to excel one or more Smartsheets, the exported workbook contains a "Comments" worksheet for each Smartsheet. I prefer to not have these Comments worksheets within the workbook. Is there a way to export without them? Nancy
-
Are webhooks a premium feature in Smartsheet?
Hi All, I'm in the process of building an app that utilizes Smartsheet's API and I would like the code to run whenever a change is made to a particular sheet. In the API's documentation, it appears that "Event Reporting" and Webhooks are my two best options. However, Event Reporting is a premium feature that is not…
-
Phone number Cell Format like Excel phone number cell Format
I can not for the life of me find where I can format cells for Phone numbers like excel. I'm having people enter in their info via a form and the phone numbers are causing immense discrepancies. Is there a way to format a column for phone numbers or selection on a form for phone number like there is for a date?