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
Pending Report - Formula Assistance Needed
Y'all... I struggle with formulas. Please help! On our sales tracking sheet, we track probability of the sale closing, expected close date, and the price low and price high of each potential sale. I'm currently using a modified version of the Sales Pipelne with Summary template. In addition to the summary (that shows…
Add date/time stamp of when another sheet was updated?
Is there a way to add a date & time stamp to a cell showing the last time the sheet was last updated and saved?
emailing a form once a checkbox has been activated
Hello out there in smartsheet land, I'm trying automate an email of a survey form. I want the form to be emailed once a check box has been checked off. I've checked the formulas page and I cannot find the help i need . Any help would be greatly appreciated. thanks Donny
Project budgeting
Hi I'm maintaining a project budget sheet but i am having a problem with a formula i have applied same formula to all columns but last column is not being linked to the total formula bar. I am using the formula =sum(children()) for all columns, can you assist me in figuring this out
Formula to Calculate all screening dates in last 7 days and last 30 days.
I am seeking a formula that will calculate all dates that occurred within the last 7 and 30 days...based on the "Screening Date" column...and should not include weekends if possible. Thank you
API programmer in Copenhagen?
University of Copenhagen - Panum - is looking for an API programmer consultant for visualisation of our building maintenance projects. Please contact us in case of interrest.
SUMIFS - Criteria person's Name & Date to SUM 3rd column with numerical value.
Purpose: To sum the hours worked per person for a given week. COLUMN 1: Name COLUMN 2: Date COLUMN 3: Hours (Integer Format) 2 independent SUMIF formulas working, but not SUMIFS together. FORMULA 1: =SUMIF(Name:Name; "Sid Organe"; [Tsk-Hrs]:[Tsk-Hrs]) Working FORMULA 2: =SUMIF(Date16:Date46; IFERROR(WEEKNUMBER(@cell); 0) =…
Collaborators (Editors) Can't See Filter Choices
Hi Everyone, I have created a sheet that is very large. I have also created filters so that each person can find the information on the sheet that pertains to them. I have clicked the button to share the filters as well. However, some of my collaborators don't even see the window with the drop-down box to choose a filter.…
Reporting Roll Up
Reporting newbie and need guidance. I have a standard sheet which has an Activity column where the drop down list is Active, Closed, Inactive, Requested, etc.) Each item in the row is tied to a dollar figure. Can Reports pull both columns, but roll up the Activity column by name into a total dollar figure? i.e. 2 rows…
Row to Form Creation
Hi all, I'm trying to set up our production planning schedule on Smartsheet. It looks like it is going to work well however I've got to an impasse... My standard sheet has 15 columns with information necessary for every job. Every row is a different job. What I need to be able to do is highlight a row, then print this row…
