Marketing
Discussion List
-
Is there a way to automatically add an entry on a monthly basis?In Using SmartsheetHi, all. I have recurring expenses monthly and it would be cool if I could have a new entry appear every month. Is there a way to do this? Thanks!
-
% Complete Column Only Works for Some Parent TasksIn Using SmartsheetI created a basic project sheet and have been filling in tasks for two main deliverables (both shown as parent rows). Under those two parent rows are several child rows. However, the % Complete column is only auto-calculating for one of th…
-
Team Calendar on MS TeamsIn Using SmartsheetHi. My team is looking to add a team travel calendar to MS Teams. I'd like to keep the MS Teams tab in the calendar view. What's the best way to easily get the calendar updated with team travel plans staying in calendar view? Thanks,…
-
Nested If with Multiple Check Box to Status TypeIn Formulas and FunctionsI was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category…
-
How to keep cell unchanged in status columnIn Using SmartsheetHi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default tha…
-
Nested If with Multiple Conditions Automation for Project ManagementIn Formulas and FunctionsHi SS Community! Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. Currently, I have this: =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(…
-
Sheet Summary Report - Want to edit fields within reportIn Using SmartsheetI created a Sheet Summary Report, and have found that the fields within the report are not editable, unlike a Row Report. In a Row Report, I can click into the cell directly within the report and update it. On my Sheet Summary Report, th…
-
Project Approval Received / Master Project Sheet PopulatedIn Formulas and FunctionsI'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…
-
HELP writing a multi-variable IF FormulaIn Formulas and FunctionsLooking for some help with automating a Health column with Red, Yellow, Gray, Green balls based on 4 corresponding values in a Status drop-down. But there are also some overrides that I want to incorporate and can't figure out. Back Log =…
-
Sheet Roll-UpIn Archived 2016 PostsI'm curious if there is a way to have a "higher level" sheet that pulls from other sheets. That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view o…
