-
Total Cost Based on Date of Task Being Finished
I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily accessible. I have tried reports but that only displays all of the costs and does not…
-
Link to a File on/from Network Location
Is there any way to add a widget that will pull up a spreadsheet, doc, etc. directly from a network drive or PC location rather than a URL or Smartsheet item?
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks
-
Filter for Current User with multiple contact column
I have created a sheet filter "my todo´s" for the current user. This works if only one contact is entered in the filtered column. But we have enable multiple contacts for that colum. Is there a possibility to build a filter "contains the current user"?
-
Move row automation with a full destination sheet
Can anyone advise what happens when you have move row automation running but your destination sheet is full? I assume the workflow stops until a new destination sheet is added in the automation logic? Many thanks!
-
Where are the phantom rows???
Hello Smartsheet Community. I searched this topic but found only variations of my specific issue. I have a simple smartsheet. 17 columns, 321 records. NO hierarchy, no attachements, nothing. Most columns are manual entry and about 4 columns are single-select entry. I have a phantom row that is presenting (not) itself in my…
-
Time function
I need to record hours in HH:MM in one of the columns of my sheet is there a time format or formula I can use so that entry format is HH:MM . I will not be tracking time in and time out, just the total time worked, for instance, if John Doe worked 7hrs and 20mins, I want to be able to enter 07:20, is this possible?
-
Look up 2 columns conditions and return 3rd column value
Hello Experts, I want to look at values from Creation Week and CR_Current Week columns and return values from CR_Start Date. I have given the lookup criteria in Column G2 and G3 and want to return the value in G4. =INDEX(ColumnD2:ColumnD14,MATCH(IF,(ColumnG2=ColumnB2:B14)*(ColumnG3=ColumnC2:ColumnC14),0)) OR…
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Actual vs target Date
Hi, Need a help if my Start Date is 05/24/2021 and end date is 07/01/2021 and in my project plan sheet say i have a task that start on 06/24/2021 and end on 06/28/2021 .However, that task is already been completed and the actual % Complete has been updated to 60% for that task i want the schedule Health should be turn to…
