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.
Discussion List
Filtered View in a Reminder
I want to use a filtered view in a reminder sent to all users of the sheet. Two other alternatives if that cannot be done would be to create a reminder in a report, or to stop the SmartSheet from displaying in the standard reminder. The goal is to send a reminder to team members that shows just the current phase of a…
Issue Calculationg Actual Durations
I have a project sheet where i added an actual start and actual finish. I also added an "actual duration" column, which is a calculated field. In that column is the following formula: =NETWORKDAYS([Actual Start]2, [Actual Finish]2) The problem is that in some cells it is showing a huge value. There isn't a rhyme or reason…
Send Update Request via API to Contact List User
Has anybody deveoped a solution using the API's to send Update Request from a sheet? Meeting with my developer to see if we can send an update request when the PAYMENT field changes to PAID status and the DATE PAYMENT RECEIVED is blank. Then send an Update Request to the User in the Agency Contact field which will be setup…
Project sheet start/finish dates
Hi all, Pretty much all my projects work over weekends. I am trying to set deadlines for start or finishes that land on either a Saturday or a Sunday, however, the project template keeps defaulting the dates back to the Friday. Any suggestions? Cheers
Formulas by today's date
I am able to figure out the fomula to count these items individual but i am running into trouble getting the correct format if i want to count # of clients that came in based on today's date at the specific location. Any help is greatly appreciated.
Bringing an already setup group into my enterprise
Before we purchased SmartSheets Enterprise we had 2 groups each using their own smartsheetss setup. However now that we have purchased the Enterprise edition 2 months back we would like to bring the small group into an already estabilished enterprise without losing permissions. I know i can import peoples sheets one by one…
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!
Basing a count formula off of the current date for the day
I am trying to create a formula where I can total up certain fields each day. Does anyone know of the formula that would allow the use of today's date in a countifs situation?
Permissions !!
I am currently using (KANBAN Sheet) to distribute tasks to my team. the problem is anyone from my team who has permission to (Edit cannot share) can drag and drop any tasks that are not assigned to them. thats make the board not under control by the admin, is there any solution that make the Admin apply restrictions to the…
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…
