Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Archived 2017 Posts
Archives for May 2017
Discussion List
Date Formula Reminders
If you set up a date on a formula, can Smartsheet still use a reminder. The questions is here that actual text in the date field is a formula displaying a date. The items are not showing up on the calendar and that is concerning. Thank you in advance.
Reminders
If I set up a reminder on a column in a the sheet, how can I make is stay forever. The reminder goes away once all dates satisfied are passed. I need this reminder to stay so that when new rows are added the portal send me reminders on the original rule.
Populating webforms with data from sheet
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking "submit" the sheet is populated. This works fine. 2) A webform is then created from the cells in the row corresponding to…
Price Book Entry Import
Dear colleagues, I am seeking for advice on the following challenge. I am using Smartsheet to update and insert Salesforce Price Book Entries. Inserting a new entry requires Price Book ID and Product ID. If I map these fields, they are imported from SFDC and won't sync to a new entry record. Similarly, if I create new…
Date Formulas
Is there a way to start a date in one cell in one columns and it add x amount of days to it is sequential columns? Ex: Row1: Name of group; Kick-off date; 14 days after kickoff date; 20 days after kickoff date, etc.... Advance thanks!
Pictures as Attachments
We use a web form on our phones to enter "issues" seen in the field. These include pictures taken by the phone. When we view these pictures later they are rotated 90d and there does not seem to be a way of fixing this short of exporting the image. Let me know if I have missed a function and if not please include a rotate…
Copying names into contact columns doesn't assign
We have about 500 rows in a sheet that need to be assigned daily. A team member will mass copy names from Excel into the contact column of our Smartsheet sheet. I would like to use the filter by "current user" functionality but, when pasting names in, the contact column does not pick up that the names are actual contacts.…
What's the statute of limitations for deleted workspaces?
I'm the account admin for my company. A user was terminated with no notice in November of 2015. I removed her account a few weeks after that. She had shared some sheets with me for technical assistance and I kept them around for at least 90 days. Sometime fairly recently (can't remember exactly, might have been less than…
Harvey Ball formula that reads across and produces cumulative
Hi All - I would like a formula that reads across vs vertically - here is my vertical one. I need the same thing but read about 10 columns status to then come up with an overall status meaning if there is 1 red, 7 yellow and 2 green then the overall cumulative status is red (lowest common denominator) Vertical Formula:…
Use "Current User" in a formula
Hoping I've not missed something obvious, but is it possible to use "Current User" in a formula? I would like a cell within a task list to count all tasks assigned to the current user with either of 2 status options. I can write the formula to pick a specific name, but want to use this number in a Sight I use to help my…