Retail
Discussion List
-
At Risk FlagsIn Formulas and FunctionsHow do I format my At Risk column so the flags only appear in the "children" rows, as shown in the screenshot?
-
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!
-
Embed countdown in SmartsheetIn Using SmartsheetI would like to embed a countdown for Go-Live into my project dashboard. Any idea?
-
Is There Really No Built-in Log\NL Function?In Archived 2017 PostsMy team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…
-
Date Modified - Copy of column creates different dateIn Formulas and FunctionsHello, I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of th…
-
Help with a FormulaIn Formulas and FunctionsI have a Target % Complete column in a project plan template that essentially looks to see if you are tracking to the % complete you should be based on today's date and the start and end date of any task (or tells you that you are missing …
-
VLOOKUP #INVALID DATA TYPE ChallengeIn Formulas and FunctionsHi! I'm new to the community and already raising an issue. Sorry about that! If anyone can help me with this, I'd greatly appreciate it. I'm trying to use VLOOKUP within a Product Roadmap sheet to set the values of the feature start d…
-
(2) Reports in a Dashboard Showing the same answer?In Using SmartsheetI have 2 reports sitting next to each other in a dashboard. One shows a summary of what was due yesterday. One shows a summary of what is due in the next 5 days. "Due Yesterday" report is set to show anything with an End Date …
-
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 =…
