department
Discussion List
-
Calculating a minimum payment figure using a formula or functionIn Formulas and FunctionsHello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my fi…
-
Link Data in a Smartsheet on a Specific Day and Make StaticIn Formulas and FunctionsI have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet. I want to create a new Smartsheet that links dat…
-
How can I automate a subtractionIn Formulas and FunctionsHey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks i…
-
Marking Oldest 5 ProjectsIn Formulas and FunctionsHello! I have been working with some data and I want to eventually be able to pull a report of my "past due" projects and show the oldest 5 projects. To do this, I have created a helper column in my source sheet that using the fo…Answered - Pending Review 25 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
How to build bar graph of submissions by userIn Formulas and FunctionsWe are using Smartsheet to build a Change Management process for our IT department. The way it currently works is we have a form that users fill out containing all the details of their change request, which are recording to a spreadsheet.…Answered - Pending Review 33 views 4 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Local Government UsesIn Using SmartsheetI am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, H…
-
OR function Not Working with Multiple Logical ExpressionsIn Formulas and FunctionsHello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. Howe…
-
I would like a formula to tell me the number of days holiday taken this monthIn Formulas and FunctionsI have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month. So far I have this: =SUMIFS(Duration:Duration, Absence:Absence, "holiday&qu…
-
Anyone experiencing issues with Dashboard Published Links not displaying in Edge or IE?In Using SmartsheetTrying to deploy our COVID-19 Dashboard and during our testing we discovered that the Published Links (set to anyone with this link) will not display in Microsoft Edge or Internet Explorer. Anyone else run into this?
-
Adding resources costIn Using SmartsheetHi all, I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I could…
