-
Formula Column - Change Status based on %Complete
I have created a Column called Formula1 and I am wanting to use this column to create a formula that will look at the %Complete and If the %Complete = 100% (1) then change the status to Complete. Currently I have the following as the formula: =IF(%Complete1 = 1, Status1 = "Complete") Problem is I am getting "#NUMBER…
-
Getting the most recent item in a column
I am trying to create a project status entry form that keeps a running log of updates - and I want to take the most recent update and roll it up to a summary report. The data sheet looks like this: (attached) Line 1 is the summary line that will link to a master scorecard elsewhere. The value of [Report Month] on line 1 is…
-
function dates difference
Hello there! I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854 how can I obtain jus a round number of days?
-
% Complete and Durations
* Hi, I am a recent user of SmartSheet and was unable to find an answer in any of the current help venues. My apologies if this is duplicated elsewhere. Here is the situation I am facing: - I have a task with a two day duration. Let's say it was set to complete yesterday. - Today, I am told that the task is only 50%…
-
TICKBOXES IN SMARTSHEET
I am trying to record telemarketing results for multiple users, who want a simple sheet to "tick" one of four boxes as to the quality of the call, every time they make one. This needs to be automatically updated, and centralised onto a single sheet, with the ability to breakdown into user and date. Ideally, we dont wish to…
-
Sending reminders to assigned techs
Can I send reminders on items that are nearing a due date that has not been marked as completed yet?
-
Cell History Reuse
HI, I have recently discovered the cell history feature... I was wandering if it is possible to to retrieve the history and use it to replace the current cell info? Pretty much, would like to revert back to the previous data in the cell... Regards, Jordan
-
Connecting two formulas
I have 2 formulas that both work. I want to merge them into one formula but it is not working. =IF((COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Red"), "Red", "Green" =IF((COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Gray"), "Gray", "Green" It might just be time for lunch but what are the rules to putting…
-
Google Calendar Sync - Guests
Hello, When using the Google Calendar Sync, is there a way to have it automatically add guests to the calendar entry? Thanks!
-
Smartsheet Charts with parameter
Hello Community, Anyone familiair wiith the charts via https://smartsheetlabs.com/ ? Is there a way to feed a chart with data without having to make a new sheet or report for every chart ? Example: - within 1 sheet I have a project which has several taks, each with planned hours and actual hours. - in a separate website, I…
