-
Why does my Modified Date keep updating when I'm not making changes?
Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows at all. In many cases those rows are filtered out of my view, so it's not even…
-
Link Data in a Smartsheet on a Specific Day and Make Static
I 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 data from the %Complete metric on a given day, and make that data static in the new…
-
Formula
Hi There, I have a list of requests that have dates that were created, so I want to run a report for all the requests that have been opened in the past 6 months from the date I am presenting my report on. Is there a formula I can use to do this calculation as I want to add this as part of my dashboard? Kind Regards Nkosi
-
SUMIF
Hello, I am trying to create a sumif formula to work out a value of column each time a name appears in a different column. I am currently using the below but it keeps coming back with #UNPARSEABLE =SUMIF([Assigned 1st]:[Assigned 1st], "[Nicola Sutton]", [Job Value]:[Job Value]
-
Turn Flag on if there is a Date in Date Completed
Simple question but not for a newbie! I would like for the Task Complete flag to show when the Date Completed field has a date in it and to not show a flag if no date. I know this should be a simple IF statement but I got stuck. Perhaps use ISDATE?? I tried this in the column for the flag: =IF(ISDATE[Date Completed]13,…
-
Changing VLookups to Index Match using a Referenced Sheet
Help! I am completely lost on making an Index Match work for current VLookups, but I believe I need to figure it out to make my sheet more usable. I have a summary sheet template that has multiple Vlookups to a large master table. It is getting unruly to try to track the column #s (over 75) with a Vlookup. Every time…
-
Automatically Populate Status - Sales Pipeline
Looking for a way to populate a Status column (up, down, unchanged) depending upon update to a Stage field. In English: If the entry in Stage changes, record in Status column for that record the DIRECTION of change. Example: Account currently in Stage B. Rep updates to Stage A today after conversation. Status should…
-
Formula to reference another sheet
Hello, I need to make a formula for the following and appear to be missing something or doing it wrong. If the Date Field is filled in, then i want the Project Manager field to fill out based on a cell in another sheet. I have the first part of =IF(Date@row >0
-
How can I automate a subtraction
Hey, 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 in advance.
-
Find Duplicates between Start and Stop Time
Hello Smart (sheet) Friends To minimize data entry errors in a timesheet application where data is entered by a supervisor for a group of individuals, I would like to identify duplicates where an employee is assigned to a task (same or different) within the same time period the employee is assigned to another task. (hey…
